ASP.NET Core 6 Entity Framework - How to Handle Concurrent Updates with a RowVersion?
I'm working on a project and hit a roadblock. I just started working with I'm trying to configure I'm stuck trying to I can't seem to get I'm having trouble with Hey everyone, I'm running into an issue that's driving me crazy. I'm sure I'm missing something obvious here, but I'm currently working on an ASP.NET Core 6 application using Entity Framework Core and I need to implement optimistic concurrency control using a `RowVersion` column in my database. I have a `Product` entity that looks 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; } } ``` I want to ensure that when a user tries to update a product, they receive an error if someone else has updated the same record since they loaded it. I have everything set up, but when I attempt to update a product that has been modified by another user, I'm encountering the following error: ``` DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s).\nDbUpdateConcurrencyException: Concurrency conflict detected. ``` I have already added the `RowVersion` property to my `Product` entity, and I'm using the following code to perform the update: ```csharp public async Task<IActionResult> UpdateProduct(int id, Product product) { if (id != product.Id) { return BadRequest(); } _context.Entry(product).OriginalValues["RowVersion"] = product.RowVersion; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { return Conflict("The product was updated by another user."); } return NoContent(); } ``` In the catch block, I'm just returning a conflict response, but I want to show a more meaningful message to the user, ideally displaying the current values from the database. I tried using `_context.Products.Find(product.Id)` to fetch the current version of the product, but I'm not sure how to properly handle and display that information. Should I re-fetch the entire product or can I just get the `RowVersion` and show the user what has changed? Also, is there anything else I need to configure in my EF context to make this work smoothly? Any guidance on best practices for handling this scenario would be greatly appreciated! For context: I'm using C# on macOS. I'm working in a CentOS environment. Any advice would be much appreciated. My team is using C# for this CLI tool. Any advice would be much appreciated. For reference, this is a production REST API. The project is a CLI tool built with C#. Is this even possible? I'm on Windows 11 using the latest version of C#. Is there a better approach? What's the best practice here? This is my first time working with C# latest. Could this be a known issue?