Entity Framework 6 - Knowledge Base (KB)

EF6 with TransactionScope - IsolationLevel.ReadUncommitted but got ReadCommitted first

There is a performance and lock issue when using EF for a update-from-query case on MSSQL 2008. So I put ...ReadUncommitted... transaction isolationlevel, hoping to resolve it, like this,...Before...using (myEntities db = new myEntities()) { v...

Running stored procedure in a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

I setup a ...DbContext... where I have this code:...base.Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;"); ...in the context constructor. I execute a stored procedure like this:...return base.Database.ExecuteSqlCommand("EXEC...