TeamFoundationSqlResourceComponent.PrepareStoredProcedure Method (String, Boolean, Int32)

Setup to execute a SQL Server stored procedure. This method will close all existing command or reader.

Namespace: Microsoft.TeamFoundation.Framework.Server
Assembly: Microsoft.TeamFoundation.Framework.Server (in Microsoft.TeamFoundation.Framework.Server.dll)


Protected Function PrepareStoredProcedure ( _
    storedProcedure As String, _
    bindPartitionId As Boolean, _
    commandTimeout As Integer _
) As SqlCommand
protected SqlCommand PrepareStoredProcedure(
    string storedProcedure,
    bool bindPartitionId,
    int commandTimeout
SqlCommand^ PrepareStoredProcedure(
    String^ storedProcedure, 
    bool bindPartitionId, 
    int commandTimeout
member PrepareStoredProcedure : 
        storedProcedure:string * 
        bindPartitionId:bool * 
        commandTimeout:int -> SqlCommand
protected function PrepareStoredProcedure(
    storedProcedure : String, 
    bindPartitionId : boolean, 
    commandTimeout : int
) : SqlCommand


  • storedProcedure
    Type: System.String

    This is the stored procedure to execute

  • commandTimeout
    Type: System.Int32

    This lets you override the time-out for this stored procedure execution

Return Value

Type: System.Data.SqlClient.SqlCommand
The SqlCommand object that is initialized

.NET Framework Security

See Also


TeamFoundationSqlResourceComponent Class

PrepareStoredProcedure Overload

Microsoft.TeamFoundation.Framework.Server Namespace