Articles

Concurrency

Concurrency...The situations in which multiple processes or users access or change the same data in a database at the same time....Concurrency Control...To implement optimistic concurrency control, you need to configure properties as concurrency tokens. So whenever an update or delete operation is performed during SaveChanges, the value of the concurrency token on the database is compared against the original value....The operation is completed successfully if the values match....If the values d...

Concurrency

Concurrency...Exception: Store update, insert, or delete statement affected an unexpected number of rows (0)...A concurrency conflict occurs when one user displays an entity's data in order to edit it, and then another user updates or deletes the same entity's data before the first user's change is written to the database....Another case for this exception is when a new object is created and and it's state is set to modified the EntityState.Modified....using (var context = new EntityContext()) {...