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)

Syntax

'Declaration
Protected Function PrepareStoredProcedure ( _
    storedProcedure As String, _
    bindPartitionId As Boolean, _
    commandTimeout As Integer _
) As SqlCommand

protected SqlCommand PrepareStoredProcedure(
    string storedProcedure,
    bool bindPartitionId,
    int commandTimeout
)

protected:
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

Parameters

• storedProcedure
  Type: System.String

  This is the stored procedure to execute

• bindPartitionId
  Type: System.Boolean

• 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

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

TeamFoundationSqlResourceComponent Class

PrepareStoredProcedure Overload

Microsoft.TeamFoundation.Framework.Server Namespace