Uploading client rows marked as Deleted are not being removed from the server database.

Unanswered Uploading client rows marked as Deleted are not being removed from the server database.

  • יום רביעי 04 יולי 2012 10:47
     
     

    I've got a simple sync setup between an iOS device and a C# service. Sync works very well, but I've noticed that when I delete rows on the client, they don't get removed from the server.

    I have two rows which I mark as isTombstone. The JSON being sent to the server has their IDs and the metadata says isDeleted.

    I've traced through the Sync Framework code on the server and I can see that the DataSet is populated as expected and the RowState is Deleted for both my rows. However, they don't get deleted from the table.

    Am I missing something?

    I should point out that the PK on the server table is long identity column, but I'm using a GUID as they primary key for Sync. Can this be causing the issue?

כל התגובות

  • יום חמישי 05 יולי 2012 01:10
    מנחה דיון
     
     

    does it report a conflict? try running profiler and see what gets passed to the stored proc.

    if your updates are working, then delete should work just the same.