I am using this transaction in SQL Server Managemnet studio 2012
begin transaction
Select *
from tabl1 with(xlock, rowlock)
where ID = 1153;
select * from Table2;
rollback
I put a breakpoint in the second query. The first query would block
the row of the Pieza which ID is 1153 while the transaction is not
commit or rollback, so when the code stop in the breakpint, in another
instance of SQL Server Management studio I do:
select * from Table1
This query I think that it would be wating until the transaction of
the first SQL Server management studio will finish, but the las query
can finish without problem.
However if I do that in a T-SQL in a transaction with EF the row is blocked.
I have tried too:
begin transaction
& ...
Go to the complete details ...