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...
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...