Locking a database row in entity framework

Question

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.

Logard · Accepted Answer · 2012-09-04 06:54:29Z

2

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!

edited Sep 4, 2012 at 6:54

answered Sep 4, 2012 at 6:49

Logard

1,5131 gold badge13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SMK Over a year ago

I think Its by default lock the whole table?

Logard Over a year ago

I think so to, so one would have to handle locks on individual rows specially.

ashwnacharya Over a year ago

How do I lock an individual row? I would not want to lock the whole table.

Community · Accepted Answer · 2014-05-28 11:20:56Z

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 }

Collectives™ on Stack Overflow

Locking a database row in entity framework

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related