I have problem in syncronization of data using microsoft sync Framework. At client I have SQL CE sdf database and at server I have normal SQL server 2008 database. I would like to apply filter on client data based on user input as mentioned below.
Say I have few records like this
ID EmpName Date 1000 Emp1 12/21/2009 1001 Emp1 12/22/2009 1002 Emp1 12/23/2009 1003 Emp1 12/24/2009 1004 Emp1 12/25/2009
The user might validate and send the records (1003,1004) first and then send other records (1000,1001,1002)