CODEWITHSUNDEEP
c#.netentity-framework
ashwnacharya
ashwnacharya

Reputation: 14881

Locking a database row in entity framework

I am using Entity framework 3.5

I need to edit a database row, and I want to ensure that no other process edits this row once I start editing it.

How do I achieve this in Entity Framework 3.5?

I am looking to lock a specific row, not an entire table.

Upvotes: 3

Views: 9865

Answers (2)

Developer
Developer

Reputation: 767

You can use Scope like this:

var transactionOptions = new TransactionOptions
{
    IsolationLevel = IsolationLevel.Serializable,
    Timeout = TimeSpan.MaxValue
};

using (var scope = new TransactionScope(
        TransactionScopeOption.Required, transactionOptions))
{
    // Your code
}

Upvotes: 1

Logard
Logard

Reputation: 1513

This can be achieved by implementing pessimistic concurrency.

Have a look at this tutorial to learn more about concurrency in EF. There are also some tutorials on the same website about how to implement different methods for handling concurrency.

Hope this helps!

Upvotes: 2

Related Questions