Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”

by

Unless there is a hidden exception that is hiding behind this as a dumb random exception, the reason is clearly stated in the exception.

Check the Id on the role object as you receive it on your Edit action and try to lookup that id in the database. The exception message you see states that, it is expecting to find a row with a matching Id of the object you attached, but it is not, so it is failing to do the update, since it could not locate a matching row to update it.

EDIT :

You are attaching the entity twice, remove the call to .Attach(role) and keep the line below it which is sufficient to add the object to the tracking context in a modified state.

//_db.Roles.Attach(role); //REMOVE THIS LINE !.
_db.Entry(role).State = Microsoft.EntityFrameworkCore.EntityState.Modified;

Beware that setting the state of the entry to modified will update all the property values upon calling .SaveChanges(), so in case you want to update only certain properties refer to this answer.

If this doesn’t solve your problem, please check for any inner exceptions that you might’ve missed. Sometimes the exception messages don’t make sense and mask the real problem which you might be able to find in the inner exception.

More Related Contents:

  1. Dynamically changing schema in Entity Framework Core
  2. How to make EF-Core use a Guid instead of String for its ID/Primary key
  3. Register AspNetCore 2.1 Identity system with DbContext interface
  4. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  5. Implementing recursive property loading in EF Core
  6. Entering keys manually with Entity Framework
  7. How to get current user in asp.net core
  8. Dynamically change connection string in Asp.Net Core
  9. .Net Core 3.0 possible object cycle was detected which is not supported
  10. .NET Core 2.1 Identity get all users with their associated roles
  11. How to add the same column to all entities in EF Core?
  12. Command dotnet ef not found
  13. How to unapply a migration in ASP.NET Core with EF Core
  14. Is there an Entity Framework 7 Database-First POCO Generator?
  15. ToArrayAsync() throws “The source IQueryable doesn’t implement IAsyncEnumerable”
  16. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  17. ASP.NET Core API only returning first result of list
  18. The entity type ApplicationUser is not part of the model for the current context
  19. User in Entity type MVC5 EF6
  20. loading a full hierarchy from a self referencing table with EntityFramework.Core
  21. Entity framework EF.Functions.Like vs string.Contains
  22. Avoid or control circular references in Entity Framework Core
  23. Configuring Dbcontext as Transient
  24. Entity Framework | Sequence contains more than one matching element
  25. Working with SQL views in Entity Framework Core
  26. How to load navigation properties on an IdentityUser with UserManager
  27. How to get user information in DbContext using Net Core
  28. How to set Identity Seed value in code-first?
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq

Leave a Comment