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.

See Also

Reference

SqlSyncTableProvisioning Class

Microsoft.Synchronization.Data.SqlServer Namespace