Locking a table with a select in Entity Framework
- by Manuel Felício
I need to be able to do
select * from myTable with (xlock,holdlock)
from Entity Framework. Is this possible? I've opened a TransactionScope with the Serializable isolation level but my selects are not locking the tables. I'd like them to lock until I complete the transaction scope.