Hi Rafik, I am new to sync services and I am using it for a new application.
I have problems to delete the records in the table Sql server compact 3.5
Scenario: I am using sync services ,(N-Tier) (http://msdn2.microsoft.com/en-us/sync/default.aspx)IntroToSyncServicesADODetNet_HighQuality.wmv
I used the designer and synchronized the tables and it works fine in N-Tier.
I want to delete the synchronized records using Linq for the (*.sdf - compact db) .
I created the Ccs.cs using Sqlmetal. Since the designer says provider not supported for this database.
Then in the code i use
Ccs db = new Ccs("Data Source=ccs.sdf;"); var deleteq = from c in db.U1 where c.Name.Contains("rajesh") select c; foreach (U1 dl in deleteq) // Also tried foreach(var dl in deleteq) db.U1.DeleteOnSubmit(dl);
db.SubmitChanges();
The code executes without error, but the data in the db remains the same, no changes. (Also for update and Insert)
What am I missing? Help me out.
Thanks, Rajesh
Moved byMax Wang_1983Friday, April 22, 2011 7:25 PM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])