TeamFoundationSqlResourceComponent.PrepareSqlBatch Method (Int32, Boolean)

Setup to execute a batch of SQL statements. 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 PrepareSqlBatch ( _
    lengthEstimate As Integer, _
    bindPartitionId As Boolean _
) As SqlCommand
protected SqlCommand PrepareSqlBatch(
    int lengthEstimate,
    bool bindPartitionId
)
protected:
SqlCommand^ PrepareSqlBatch(
    int lengthEstimate, 
    bool bindPartitionId
)
member PrepareSqlBatch : 
        lengthEstimate:int * 
        bindPartitionId:bool -> SqlCommand
protected function PrepareSqlBatch(
    lengthEstimate : int, 
    bindPartitionId : boolean
) : SqlCommand

Parameters

  • lengthEstimate
    Type: System.Int32

    Best guess of the number of characters in the SQL statements to be executed. Does not have to be exact.

  • bindPartitionId
    Type: System.Boolean

    If true, the current service host partition id is bound to @partitionId

Return Value

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

.NET Framework Security

See Also

Reference

TeamFoundationSqlResourceComponent Class

PrepareSqlBatch Overload

Microsoft.TeamFoundation.Framework.Server Namespace