How to handle cancel of updates in LINQ to SQL?

Question

Hi,

In our desktop application,we bind grids to data.Now,for example a grid is showing records of customers.The user can edit any record,and click save.Instead of save, he can click cancel too.I am able to get originalstate of all objects and show their values in the grid.But,I have not found a way to cancel\clear updates collection as it is readonly.What happens is, that user again say makes some changes, and clicks save,earlier updates collection still exists.

Answer 1

I have run into this same issue. I believe the only effective way to do this is to discard your original data context object and create a new one.

Randy