Entity Framework: “Store update, insert, or delete statement affected an unexpected number of rows (0).” [closed]

by

I ran into this and it was caused by the entity’s ID (key) field not being set. Thus when the context went to save the data, it could not find an ID = 0. Be sure to place a break point in your update statement and verify that the entity’s ID has been set.

From Paul Bellora’s comment

I had this exact issue, caused by forgetting to include the hidden ID
input in the .cshtml edit page

More Related Contents:

  1. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  2. Improving bulk insert performance in Entity framework [duplicate]
  3. Unique Constraint in Entity Framework Code First
  4. The specified type member ‘Date’ is not supported in LINQ to Entities Exception
  5. EntityFramework code-first custom connection string and migrations
  6. How do I detach objects in Entity Framework Code First?
  7. No executable found matching command “dotnet-ef”
  8. How to ensure proxies are created when using the repository pattern with entity framework?
  9. Entity Framework Code First – No Detach() method on DbContext
  10. Debug code-first Entity Framework migration codes
  11. Entity framework core update many to many
  12. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  13. Package Manager Console Enable-Migrations CommandNotFoundException only in a specific VS project
  14. Unique keys in Entity Framework 4
  15. How to create index in Entity Framework 6.2 with code first
  16. How can I disable code first migrations
  17. Upgrade EF 4 EDMX to EF 6
  18. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  19. ObjectContext.Refresh()?
  20. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  21. Stuffing an anonymous type in ViewBag causing model binder issues
  22. What is the syntax for self referencing foreign keys in EF Code First?
  23. what is difference between a Model and an Entity
  24. check constraint entity framework
  25. int to string in Entity Framework
  26. Changes in IDENTITY column after EF core 3
  27. What would cause the Entity Framework to save an unloaded (but lazy loadable) reference over existing data?
  28. DbContext AutoDetectChangesEnabled set to false detecting changes
  29. Using the Entry().CurrentValues.SetValues() is not updating collections
  30. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key

Leave a Comment