Hello,
I have a Windows Form application using LINQ to SQL. It's working all good and fine but there is one thing I fail to understand.
In one of the forms, I have a DataGrid which shows a list of order items. When I save them using SubmitChanges(), in the first call (after the application has been run) it saves the ALL the order items in the database regardless of how many rows in the grid were changed.
After that first time, it only saves the row which are changed unless I shut down my application and run it again.
This first call of saving all the rows regardless whether they were changed or now really slows up my Synching/Replication as it updates the timestamps of all the rows.
I am slightly confused here. Can anyone explain me this behaviour.
Note: I am using a Stored Procedure to save my order items. So basically that procedure gets executed for each order item once SubmitChanges() is called.