Hello -
You pretty much prefer to delete some information/rows on the local SQL CE store (due to some business logic change) with being sent to the server. The hight level guideline is that
1. If you have prefer deleting some rows locally, please record them so that you can identify them in a later stage.
1.1 Hook up the event ChangesSelected to the SqlCeClientSyncProvider.
2. Do the normal bi-directional or upload sync. These locally deleted changes will also be part of the enumeration in the dataset.
3. Once changes is completed in enumeration, the ChangesSelected event is fired upon SqlCeClientSyncProvider. At this moment, please exam all data rows in each data table of the enumerated dataset (which can be got as a property of the event argument)
and find out if any rows are deleted "on purpose" when compared to step #1. If it is, then remove it from the corresponding data table from the dataset. In this case, the data set applied on the server will not contain the rows which you do not
like server to delete.
Thanks.
Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.