Concurrency management deals with allowing multiple entities to be updated simultaneously. This means effectively allowing multiple database operations on the same data simultaneously. Concurrency is a way of managing multiple operations on a database and at the same time allowing atomicity, consistency, isolation, and durability (ACID) properties of the database operations.
Note
In this chapter, we will not be discussing the details of ACID properties but we will instead focus on how to manage concurrency using Entity Framework. You are advised to read about database ACID properties if you don't know about it as this will be very helpful in understanding this and the next chapter.
To understand the problem, let's take a look at a few concurrency scenarios. Let's say we have two users accessing the same database. Here are a few scenarios where concurrent access can lead to some potential problems:
User 1 and user 2 are both trying to update the same entity
User 1 and...