Entity Framework 6 - Knowledge Base (KB)

Locking tables in Entity Framework

I have an SQL Database with a table that I would like to lock. I'm using Entity Framework. Basically, there are a number of processes that each want to write to the database concurrently. Each of them wants to update a row in some table. However, I want o...

Pessimistic locking in EF code first

I'd like to lock specified row(s) in my table exclusively, so no reads no updates allowed until the actual transaction completes. To do this, I've created a helper class in my database repository:...public void PessimisticMyEntityHandler(Action<IEnumerabl...