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)

Syntax

'Declaration
Protected Function PrepareStoredProcedure ( _
    storedProcedure As String, _
    commandTimeout As Integer _
) As SqlCommand
protected SqlCommand PrepareStoredProcedure(
    string storedProcedure,
    int commandTimeout
)
protected:
SqlCommand^ PrepareStoredProcedure(
    String^ storedProcedure, 
    int commandTimeout
)
member PrepareStoredProcedure : 
        storedProcedure:string * 
        commandTimeout:int -> SqlCommand
protected function PrepareStoredProcedure(
    storedProcedure : String, 
    commandTimeout : int
) : SqlCommand

Parameters

  • 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

Reference

TeamFoundationSqlResourceComponent Class

PrepareStoredProcedure Overload

Microsoft.TeamFoundation.Framework.Server Namespace