Friday, September 9, 2011
Thursday, September 8, 2011
How to solve "deadlocked on lock resources with another process and has been chosen as the deadlock victim" in Entity Framework?
One of
options is to set TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED
FrameEntities entities = new FrameEntities();
entities.ExecuteStoreCommand("SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED;");
READ UNCOMMITTED level is the least restrictive of the four isolation levels.
Subscribe to:
Posts (Atom)