I'd like to get my brain wrapped around the ADO.NET Sync Services. I think it's a great concept. Ultimately I want to keep a SQL Server database (table) and a SQL Server Compact Edition 3.5 SP1 database (table) sync'd. I'll use a WCF service to get the data from the SQL Server and sync the info back and forth.

So far the ADO.NET Sync Services is a little over my head. I also can't just "drop" a table as we have a multi-user setup. For example, I may just need to sync data for UserID=1. All tables have a UserID FK to distinguish who's data is who's.

Anyone have any experience with the Sync Framework. Is it worth the effort or did you roll your own sync system? I'd like to start out just by syncing a table in a dataset. I'll get a DataSet from the Server and compare a table from a DataSet from SSCE. Once I can grasp that I'll move on to bigger and better usage!

Thx