"Row Not Found or Changed" Error Pops Up Randomly

Question

When I run

DB.SubmitChanges();

I occasionally get an error that reads: "Row not found or changed". The reason why this error bugs me so much is because there will always a row that should be found for this query, and changes are only made if there are new changes to make.

I can't seem to figure out why this error pops up Are there some common reasons why this error shows up that I can try to find in my code?

Answer 1

There could be 2 reasons:

• the Row was deleted
• the row was changed by another client

Both are due to concurrency, the first thing to check is if this could indeed be a multi-user issue.