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.

No comments:

Post a Comment