ASP.NET MVC multiple threads access database simultaneously

Question

I am building a ASP.NET MVC 4 app using Entity Framework where multiple threads can access a table at the same time (add, delete row, etc.) Right now I am doing using (UserDBContext db = new UserDBContext()) within each controller (so a new DBContext is created for each request since MVC framework creates a seperate thread for each request). From what i read, this is safe; however, I am curious about:

What happens when two threads access the same table, but not the same row? Are both threads allowed to access simultaneously?
What happens when two threads modify the same row? say, one tries to read while the other tries to delete? Is one thread blocked (put to sleep), then gets waken up automatically when the other is done?

Thanks!

adiga · Accepted Answer · 2014-11-20 07:27:05Z

4

1: Locking in the database. Guaranteeing multi user scenarios is one of the top priority of databases. Learn the basics. There are good books.

2: Locking. Again. One will have to wait.

This is extremely fundamental so I would suggest you take 2 steps back and get something like "SQL for dummies" and learn about ACID conditions that any decent database guarantees. NOTHING in here has to do with EF by the way. This is all done on the database internal level.

edited Nov 20, 2014 at 7:27

adiga

35.4k9 gold badges65 silver badges88 bronze badges

answered Nov 20, 2014 at 6:16

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

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

1 Comment

Pavel Voronin Over a year ago

+3: Optimistic concurrency

Collectives™ on Stack Overflow

ASP.NET MVC multiple threads access database simultaneously

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related