SqlSyncTableProvisioning.UseBulkProcedures Property
Gets or sets a value that indicates whether the bulk procedures should be created during provisioning.
Namespace: Microsoft.Synchronization.Data.SqlServer
Assembly: Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)
Syntax
'Declaration
Public Property UseBulkProcedures As Boolean
Get
Set
'Usage
Dim instance As SqlSyncTableProvisioning
Dim value As Boolean
value = instance.UseBulkProcedures
instance.UseBulkProcedures = value
public bool UseBulkProcedures { get; set; }
public:
property bool UseBulkProcedures {
bool get ();
void set (bool value);
}
member UseBulkProcedures : bool with get, set
function get UseBulkProcedures () : boolean
function set UseBulkProcedures (value : boolean)
Property Value
Type: System.Boolean
true if the bulk procedures are created during provisioning; 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.