EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]

by

I get the following error:
Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF.

I think that the IDENTITY_INSERT is the Auto Increment functionality which is off.
So, check the field PersonId in the database to see if it is an identity.

Besides, maybe this will fix your problem too.

[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int PersonId { get; set; }

More Related Contents:

  1. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  2. Disable lazy loading by default in Entity Framework 4
  3. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  4. How to include a child object’s child object in Entity Framework 5
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  7. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  8. Unique keys in Entity Framework 4
  9. Entity Framework 4 selective lazy loading properties
  10. Upgrade EF 4 EDMX to EF 6
  11. Querying objects after AddObject before SaveChanges?
  12. EF Migrations: Rollback last applied migration?
  13. Using Entity Framework with an SQL Compact Private Installation
  14. Map two different entities to the same table?
  15. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  16. AutomaticMigrationsEnabled false or true?
  17. Compose queries across Entity Data Models
  18. Changing Inherited Types in Entity Framework
  19. Convert String to Int in EF 4.0
  20. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  21. EF5 Code First Enums and Lookup Tables
  22. Entity Framework One-To-One Mapping Issues
  23. How can I delete 1,000 rows with EF6?
  24. Internal .NET Framework Data Provider error 1025
  25. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import)
  26. Adding Validation Attributes With an Entity Framework Data Model
  27. Ramifications of DbSet.Create versus new Entity()
  28. Entity Framework Code Only error: the model backing the context has changed since the database was created
  29. Entity Framework : How do you refresh the model when the db changes?
  30. EF Code First DBContext and Transactions

Leave a Comment