WCF Data Services - How to delete item from that does not exist in the database?

Question

I am using WCF Data Services and let's say a user creates a row in a datagrid (via AddObject) and then decides they do not want it after all so they would like to go ahead and delete it.

So in this scenario, the item is in the DataContext but no in the Database yet. How can I do this?

Any advice will be greatly appreciated.

Answer 1

You need to be able to detect that a row has been added locally (e.g. by setting it's primary key column to a negative value or something, or by having a specific flag).

When the user deletes a row from your grid, you need to check whether or not that's a row that needs to be deleted from the database / WCF Data Service or not.