sync framework example with tutorial over wcf

Question

Hi All,

I am working on a smart client project which works offline also.

I want to use sync framework to do this job over WCF. My scenario is like my client applications will download some static data from WCF service and update its local database.

Work in offline mode, do all transactions and finally sync back to server should be using WCF. Here everything should be passed from wcf only.

Issue 1 – we have lots of tutorials on internet and code sample available. But none of it is clear and gives proper direction, all are too confusing. Please provide some tutorial to framework and code samples to do this job over wcf.

Issue 2 – As we have used primary key as identity column in table, which I read can cause problems. What could be best solution for it. We do have branch code also in table but not as part of primary key.

Thanks

Answer 1

There is an N-Tier sample:
Database Sync:SQL Server and SQL Express N-Tier with WCF
http://code.msdn.microsoft.com/windowsdesktop/Database-SyncSQL-Server-e97d1208

If the client side uses SqlCe, there is another sample WebSharingAppDemo-CEProviderEndToEnd in Sync Framework 2.1 SDK Samples folder.

Hope this might help. Thanks.