Running stored procedure in a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

c# entity-framework-6 read-uncommitted sql-server stored-procedures

Question

I created aDbContext 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?

1
0
11/10/2017 6:16:38 PM

Accepted Answer

ZZZ_tmp
1
11/11/2017 12:51:54 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow