Locking a table with a select in Entity Framework

Posted by Manuel Felício on Stack Overflow See other posts from Stack Overflow or by Manuel Felício
Published on 2009-10-26T16:31:45Z Indexed on 2010/04/06 22:03 UTC
Read the original article Hit count: 357

Filed under:

entity-framework

|

transactionscope

|

table-locking

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.

© Stack Overflow or respective owner

Related posts about entity-framework

Differences Between NHibernate and Entity Framework

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction NHibernate and Entity Framework are two of the most popular O/RM frameworks on the .NET world. Although they share some functionality, there are some aspects on which they are quite different. This post will describe this differences and will hopefully help you get started with the one… >>> More
Entity Framework & Binding syncronisation

as seen on Stack Overflow - Search for 'Stack Overflow'
* EDIT * Sorry, I should make it clearer. Imagine I have an entity: public class MyObject { public string Name { get; set; } } And I have a ListBox: <ListBox x:Name="lbParts"> <ListBox.ItemTemplate> <DataTemplate> <TextBlock Text="{Binding Name}"/> … >>> More
Joins and UI Binding with the Entity Framework

as seen on Internet.com - Search for 'Internet.com'
Learn how to build queries with the Entity Framework that involve multiple tables as well as binding in the UI with the EntityDataSource. >>> More
Frederick .NET User Group April 2010 Meeting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
FredNUG is pleased to announce that we have an excellent speaker lined up for April. On April 20th, we’ll start with pizza and social networking at 6:30 PM. Then, starting at 7 PM, Dane Morgridge will present “Getting Started with Entity Framework 4” The scheduled agenda is: 6:30 PM - 7:00… >>> More
[News] NHibernate vs MS Entity Framework

as seen on Dot Net Guru - Search for 'Dot Net Guru'
Voil? une question qui se posera de plus en plus avec la sortie prochaine de .NET V4 et Entity Framework V4, l'outil de mapping objet/relationnel de Microsoft. M?me s'il est vrai que l'opinion de Ayende peut para?tre biais?e du fait qu'il est contributeur NHibernate, son point de vue et surtout ses… >>> More

Related posts about transactionscope

TransactionScope and Connection Pooling

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to get a handle on whether we have a problem in our application with database connections using incorrect IsolationLevels. Our application is a .Net 3.5 database app using SQL Server 2005. I've discovered that the IsolationLevel of connections are not reset when they are returned… >>> More
Why is TransactionScope operation is not valid?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a routine which uses a recursive loop to insert items into a SQL Server 2005 database The first call which initiates the loop is enclosed within a transaction using TransactionScope. When I first call ProcessItem the myItem data gets inserted into the database as expected. However when ProcessItem… >>> More
Setting the database connection when using a TransactionScope

as seen on Stack Overflow - Search for 'Stack Overflow'
Does the database connection have to be set inside a TransactionScope? Or can I set it in the ctor and then have instance methods create up a TransactionScope? EDIT: e.g. Public Sub New() Dim conn = new SqlConnection(...connection string) Public Sub SomeClassMethod() using ts as new TransactionScope … >>> More
Membership.GetUser() within TransactionScope throws TransactionPromotionException

as seen on Stack Overflow - Search for 'Stack Overflow'
The following code throws a TransactionAbortedException with message "The transaction has aborted" and an inner TransactionPromotionException with message "Failure while attempting to promote transaction": using ( TransactionScope transactionScope = new TransactionScope() ) { try … >>> More
Membership.GetUser() within TransactionScope throws TransactionAbortedException

as seen on Stack Overflow - Search for 'Stack Overflow'
The following code throws a TransactionAbortedException with message "The transaction has aborted": using ( MyDataContext context = new MyDataContext() ) { using ( TransactionScope transactionScope = new TransactionScope() ) { Guid accountID… >>> More