Answer
Use a RowVersion (timestamp) column.
EF detects conflicts and throws DbUpdateConcurrencyException.
Quick Answer
Optimistic concurrency: add a rowversion/timestamp column. EF Core adds it to UPDATE WHERE clause - if another process changed the row, the WHERE fails (0 rows affected) and throws DbUpdateConcurrencyException. Handle: catch the exception, reload the entity (fresh values), show conflict to user or auto-merge based on rules. [Timestamp] attribute on byte[] property enables rowversion-based concurrency.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ