0
votes

I am looking to develop an application for windows laptops to work with or without internet connection. I was looking at MS Sync, which very much provides the solution. I have SQL Server 2008 at my server. I can have SQL Server CE or SQL Server Express on client. SQL Server Express gives me an advantage of using stored procs etc. while SQL CE is lot less powerful. Since my server db is hosted at a public server I do not want to expose it directly to the application. So I was looking to do the synchronization using WCF web services. But I am unable to find client sync provider for the same.

1

1 Answers

0
votes

you can find samples here for using Sync Framework with WCF.

Database Sync: SQL Server and SQL Compact N-Tier with WCF

Database Sync:SQL Server and SQL Express N-Tier with WCF

you might have to tweak the samples though because the client application directly references the service assembly.