Question
Is there any way to make Entity Framework generate select queries with write lock: SELECT ... FOR UPDATE?
Accepted Answer
The first result of googling for "entity framework linq select with lock" gave the answer you want. Check this out: http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/thread/5219035b-aaa9-4917-b2f2-852b5d8449ea/
Here's an idea though. You can create a stored procedure where you select with lock. Then call that stored procedure via entity framework's generated context.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
