Share via

SqlCeClientSyncProvider.ApplyChanges Method

  • Article

Applies inserts, updates, and deletes for a synchronization group to the client database.

Remarks

This method assumes that the table is in the client database; otherwise, the method throws an exception. If the table exists but tracking is not enabled, bidirectional tracking is enabled. Rows are marked with a DataRowState value to differentiate between inserts, updates, and deletes.

Changes are applied in the following order: deletes, inserts, and then updates. The order in which changes are applied to each table in a synchronization group depends on the order in which tables are added to the group. Deletes are applied in reverse of the order in which the tables are added. Inserts and updates are applied in the order in which the tables are added.

For example, if you add the table SalesOrderHeader and then add SalesOrderDetail to the same synchronization group, the following processing order is used during synchronization:

  1. Deletes are applied to SalesOrderDetail and then SalesOrderHeader.

  2. Inserts are applied to SalesOrderHeader and then SalesOrderDetail.

  3. Updates are applied to SalesOrderHeader and then SalesOrderDetail.

Overload List

Name Description
SqlCeClientSyncProvider.ApplyChanges (Generic , DataSet, SyncAnchor)
Applies inserts, updates, and deletes for a synchronization group to the client database when given table names, a data set, and server anchor parameters.
SqlCeClientSyncProvider.ApplyChanges (String, DataSet, SyncAnchor)
Applies inserts, updates, and deletes for a synchronization group to the client database when given a table name, a data set, and server anchor parameters.
SqlCeClientSyncProvider.ApplyChanges (SyncGroupMetadata, DataSet, SyncSession)
Applies inserts, updates, and deletes for a synchronization group to the client database when given group metadata, a data set, and synchronization session parameters.

See Also

Reference

SqlCeClientSyncProvider Class
SqlCeClientSyncProvider Members
Microsoft.Synchronization.Data.SqlServerCe Namespace