Has anyone here worked with Sync Framework and syncing through WCF endpoints? Please share code samples or sample projects. I am specifically looking for offline scenarios where client comes online only to fetch updates from the Server.
C# – Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework
cmicrosoft-sync-frameworknetsql-server-2008
Best Answer
I did the following to get Sync Framework working using WCF with SQL Server 2008
Used SqlSyncAdapterBuilder to build adapters for tables participating in the Sync
Added anchor commands
Implemented a WCF Service using a instance of DbServerSyncProvider functioning as Server sync provider. You will have generate sync adapters and set anchor command as shown in previous step for Server provider too.
Created a proxy class implementing ServerSyncProvider to access WCF service