System.Data.OptimisticConcurrencyException

Hi All,

I am using Entity framework Code first. I am seeing bellow error when an entity object updating. it is not happening regularly. restarting the windows service is fixing this issue

See the details bellow

An error occurred while saving entities that do not expose foreign key properties for their relationships. The EntityEntries property will return null because a single entity cannot be identified as the source of the exception. Handling of exceptions while saving can be made easier by exposing foreign key properties in your entity types. See the InnerException for details.Inner Exception: System.Data.OptimisticConcurrencyException: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.

at System.Data.Mapping.Update.Internal.UpdateTranslator.ValidateRowsAffected(Int64 rowsAffected, UpdateCommand source)

at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)

at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)

at System.Data.Entity.Internal.InternalContext.SaveChanges()

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
By default EF supports optimistic con-currency. Means user1 retrieves data and same time user2 retrieve same data. But user1 submit data it saved successfully but user2 tried to submit data. As user1 submit data is different than user2 retrieve data. So it mismatch. Go through below link:

http://www.entityframeworktutorial.net/EntityFramework5/handle-concurrency-in-entity-framework.aspx
0