Entity Framework error: Cannot insert explicit value for identity column in table

by

I have run into this before. This error means you are trying to assign a value explicitly to a column where the database automatically assigns it.

Suggestion:
Update your edmx file to reflect any changes you may have made in the database.
If the database automatically assigns the value, you should see the “IsDbGenerated=true” attribute in your designer file under that property. If it’s not there, you can add it manually.

More Related Contents:

  1. Fastest Way of Inserting in Entity Framework
  2. Entering keys manually with Entity Framework
  3. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. LINQ to SQL multiple tables left outer join
  6. Entity Framework. Delete all rows in table
  7. Entity Framework – stored procedure return value
  8. EF 6 Parameter Sniffing
  9. Retrieve an object from entityframework without ONE field
  10. Join and Include in Entity Framework
  11. Anonymous type result from sql query execution entity framework
  12. Calling a SQL User-defined function in a LINQ query
  13. Stored procedure returns int instead of result set
  14. How to use String property as primary key in Entity Framework
  15. Querying data using Entity Framework from dynamically created table
  16. How to save leap date ’02/29/2006′ to sql server database? [duplicate]
  17. What is the purpose of self tracking entities?
  18. Read SQL Table into C# DataTable
  19. Entity Framework/Linq EXpression converting from string to int
  20. Creating Composite Key Entity Framework
  21. Entity Framework Code First Lazy Loading
  22. How to add the same column to all entities in EF Core?
  23. Dynamically changing schema in Entity Framework Core
  24. Enable-Migrations Exception calling “SetData” with “2” argument(s)
  25. Generate class from database table
  26. Save detached entity in Entity Framework 6
  27. How do you check if a string contains any strings from a list in Entity Framework?
  28. Cannot find command ‘dotnet ef’
  29. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  30. How to create custom additional fields in UserProfile in MVC4

Leave a Comment