My app uses SQL Server 2008 and SQL Server CE SP1 on the client. I have recently seperted the server providor into a sevice which runs on the SQL Server machine. The client connects to it, using a tcp connection using wcf. Do I need to
have a locking mechanism to ensure that 2 users do not sync at the same time?
Also I was thinking of riting the last anchor for each client inot a table at the server at the end of each sync session. This would allow me to know ,from the server, when the last time each client sync'ed and which data they have.
Any thoughts?