SqlCeClientSyncProvider.ApplyChanges Method (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.

Namespace:  Microsoft.Synchronization.Data.SqlServerCe
Assembly:  Microsoft.Synchronization.Data.SqlServerCe (in Microsoft.Synchronization.Data.SqlServerCe.dll)

public SyncContext ApplyChanges(
	string tableName,
	DataSet dataSet,
	SyncAnchor serverAnchor


Type: System.String
A table in the client database for which to apply changes.
Type: System.Data.DataSet
A DataSet object that contains the rows of data to be applied to the database.
Type: Microsoft.Synchronization.Data.SyncAnchor
A SyncAnchor object that represents the NewAnchor value for this synchronization session.

Return Value

Type: Microsoft.Synchronization.Data.SyncContext
A SyncContext object that contains data changes and anchor values and other metadata for a synchronization session.


tableName or dataSet is a null.


Another transaction is in progress.

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.