How can I force entity framework to insert identity columns?

by

EF 6 method, using the msdn article:

using (var dataContext = new DataModelContainer())
using (var transaction = dataContext.Database.BeginTransaction())
{
    var user = new User()
    {
        ID = id,
        Name = "John"
    };

    dataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[User] ON");

    dataContext.User.Add(user);
    dataContext.SaveChanges();

    dataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[User] OFF");

    transaction.Commit();
}

Update: To avoid error “Explicit value must be specified for identity column in table ‘TableName’ either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column”, you should change value of StoreGeneratedPattern property of identity column from Identity to None in model designer.

Note, changing of StoreGeneratedPattern to None will fail inserting of object without specified id (normal way) with error “Cannot insert explicit value for identity column in table ‘TableName’ when IDENTITY_INSERT is set to OFF”.

More Related Contents:

  1. thread messaging system database schema design
  2. Entity Framework 4 – Update database schema from model. Without wiping the table data
  3. Unable to Retrieve Metadata
  4. Store pictures as files or in the database like MSSQL for a web app?
  5. what’s the issue with AttachDbFilename
  6. Are Parameters really enough to prevent Sql injections?
  7. ASP.NET Identity DbContext confusion
  8. How to “warm-up” Entity Framework? When does it get “cold”?
  9. How do I add ROW_NUMBER to a LINQ query or Entity?
  10. How and where to call Database.EnsureCreated and Database.Migrate?
  11. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  12. Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?
  13. How to warm up an ASP.NET MVC application on IIS 7.5?
  14. How to disable cascade delete for link tables in EF code-first?
  15. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  16. It has a DefiningQuery but no InsertFunction element… err
  17. Display image from database in ASP.net with C#
  18. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  19. Preventing SQL Injection in ASP.Net
  20. Images in database vs file system
  21. Optimistic concurrency: IsConcurrencyToken and RowVersion
  22. There is already an object named in the database
  23. How do I programmatically set the connection string for Entity-Framework Code-First?
  24. Streaming Databased Images Using HttpHandler
  25. Entity framework context as static
  26. Difference between DropDownlist or DropDownListFor Html helper
  27. Unit-testing .ToListAsync() using an in-memory
  28. How to Specify Primary Key Name in EF-Code-First
  29. Entity Framework v2 doesn’t support sql 2000?
  30. What’s the best way to display an image from a sql server database in asp.net?

Leave a Comment