Entity Framework Write Lock When Selected

Question

Is there a way to get the Entity Framework to generate selected records with a write lock: SELECT ... FOR UPDATE?

Answer 1

The first search result for "linq select with lock frame entity" gave the answer you want. Check this out: http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/thread/5219035b-aaa9-4917-b2f2-852b5d8449ea/

That’s the idea. You can create a stored procedure that you select with a lock. Then call this stored procedure through the generated context of the framework.