TeamFoundationSqlResourceComponent.PrepareStoredProcedure Method (String, Int32)

Setup to execute a SQL stored procedure. This method will close all existing commands or readers.

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


Protected Function PrepareStoredProcedure ( _
    storedProcedure As String, _
    commandTimeout As Integer _
) As SqlCommand
protected SqlCommand PrepareStoredProcedure(
    string storedProcedure,
    int commandTimeout
SqlCommand^ PrepareStoredProcedure(
    String^ storedProcedure, 
    int commandTimeout
member PrepareStoredProcedure : 
        storedProcedure:string * 
        commandTimeout:int -> SqlCommand
protected function PrepareStoredProcedure(
    storedProcedure : String, 
    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