I created a
I have this code here:
base.Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;");
while creating the context. I run a stored procedure like follows:
return base.Database.ExecuteSqlCommand("EXEC mystoredprocedure");
However, since this runs in a read committed connection, I'm seeing a stalemate.
If the stored procedure is a component of the context that has the read uncommitted connection, is there any reason it would execute in a read committed manner instead?