SqlSyncScopeProvisioning.SetUseBulkProceduresDefault Method
Sets a value that indicates whether bulk procedures should be created when provisioning stored procedures. The default setting is true when provisioning a SQL Server 2008 or SQL Azure database; otherwise, it is false.
Namespace: Microsoft.Synchronization.Data.SqlServer
Assembly: Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)
Syntax
'Declaration
Public Sub SetUseBulkProceduresDefault ( _
useBulk As Boolean _
)
'Usage
Dim instance As SqlSyncScopeProvisioning
Dim useBulk As Boolean
instance.SetUseBulkProceduresDefault(useBulk)
public void SetUseBulkProceduresDefault(
bool useBulk
)
public:
void SetUseBulkProceduresDefault(
bool useBulk
)
member SetUseBulkProceduresDefault :
useBulk:bool -> unit
public function SetUseBulkProceduresDefault(
useBulk : boolean
)
Parameters
- useBulk
Type: System.Boolean
true if bulk procedures should be provisioned; otherwise false.
Remarks
Bulk procedures take advantage of the table-valued parameter feature of SQL Server 2008 and SQL Azure to apply multiple inserts, updates, and deletes by using a single stored procedure call, instead of requiring a stored procedure call to apply each change. This greatly increases performance of these operations and reduces the number of trips between client and server during change application.
Be aware that after bulk procedures are created for a table, they are always used for all scopes that include the table, even scopes that specified that bulk procedures should not be used. Also, if a table has already been provisioned for another scope that uses bulk procedures, specifying false to SetUseBulkProceduresDefault has no effect.