You use DataContext to execute a query on a database. Your code modifies returned objects. You need to submit all changes and handle any conflicts.

What should you do

Call DataContext.SubmitChanges with ContinueOnConflict to ensure that all row updates are attempted.

Handle the ChangeConflictException to detect conflicts.

Iterate through the DataContext.ChangeConflicts collection to examine and handle specific conflicts