Handling Data Concurrency with Entity Framework Core in ASP.NET Core 5.0
I'm migrating some code and Hey everyone, I'm running into an issue that's driving me crazy. I just started working with I'm getting frustrated with I'm currently working on an ASP.NET Core 5.0 application where I'm using Entity Framework Core for data access... I've implemented a simple CRUD operation for a `Product` entity, but I'm facing issues with data concurrency. When two users try to update the same product simultaneously, the last update overwrites the previous one without any warnings. I've tried enabling optimistic concurrency by adding a `RowVersion` property to my `Product` entity like this: ```csharp public class Product { public int Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } [Timestamp] public byte[] RowVersion { get; set; } } ``` In my `DbContext`, I have configured the model like so: ```csharp protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<Product>() .Property(p => p.RowVersion) .IsRowVersion(); } ``` Moreover, when I perform an update in the controller, I'm attempting to catch `DbUpdateConcurrencyException`: ```csharp public async Task<IActionResult> UpdateProduct(int id, Product product) { if (id != product.Id) { return BadRequest(); } _context.Entry(product).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException ex) { // Handle concurrency conflict var databaseEntity = await _context.Products.FindAsync(id); if (databaseEntity == null) { return NotFound(); } // Here I would like to show the user the current values from databaseEntity // Currently, I just log the error message out Console.WriteLine(ex.Message); return Conflict("Concurrency conflict occurred."); } return NoContent(); } ``` When I test this scenario, I'm able to log the `DbUpdateConcurrencyException`, but I’m unsure how to provide feedback to the user regarding the current values in the database. What’s the best practice to inform them about the conflicting changes and show the latest values from the database? Furthermore, how can I ensure that the update process is more intuitive, possibly merging changes or prompting the user to accept the new values? Any advice on handling this gracefully would be greatly appreciated! For context: I'm using C# on macOS. For context: I'm using C# on macOS. What's the best practice here? Any advice would be much appreciated. My team is using C# for this REST API. Is there a better approach? How would you solve this? What's the correct way to implement this?