How do I handle a failed SubmitChanges in LinqToSql?

Question

If the db.SubmitChanges failed for whatever reason, I want to return a failed message.

DO I just catch the error or does the ConflictMode help here?

Answer 1

The FailOnFirstConflict specifies that attempts to update the database should stop immediately. ContinueOnConflict specifies that all updates to the database should be tried.

The latter may lead to inconsistent results, depending on the type of save/update you are performing.

So unless this is not relevant to you, simply return the first error by using FailOnFirstConflict.