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)

public:
property bool UseBulkProcedures {
	bool get ();
	void set (bool value);
}

Property Value

Type: System::Boolean
true if the bulk procedures are created during provisioning; otherwise, false.

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.

Show: