Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction

by

The ID is generated by the database after the row is inserted to the table. You can’t ask the database what that value is going to be before the row is inserted.

You have two ways around this – the easiest would be to call SaveChanges. Since you are inside a transaction, you can roll back in case there’s a problem after you get the ID.

The second way would be not to use the database’s built in IDENTITY fields, but rather implement them yourself. This can be very useful when you have a lot of bulk insert operations, but it comes with a price – it’s not trivial to implement.

EDIT: SQL Server 2012 has a built-in SEQUENCE type that can be used instead of an IDENTITY column, no need to implement it yourself.

More Related Contents:

  1. One DbContext per web request… why?
  2. Solving “The ObjectContext instance has been disposed and can no longer be used for operations that require a connection” InvalidOperationException
  3. Entering keys manually with Entity Framework
  4. How can I retrieve Id of inserted entity using Entity framework? [closed]
  5. Entity Framework Timeouts
  6. Getting data from stored procedure with Entity Framework
  7. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  8. Entity Framework Refresh context? [closed]
  9. The instance of entity type cannot be tracked because another instance of this type with the same key is already being tracked
  10. The result of a query cannot be enumerated more than once
  11. Dynamic MySQL database connection for Entity Framework 6
  12. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  13. SQL Injection attack prevention: where do I start
  14. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  15. get date part only from datetime value using entity framework
  16. ASP.NET Identity – Multiple object sets per type are not supported
  17. The entity type ApplicationUser is not part of the model for the current context
  18. User in Entity type MVC5 EF6
  19. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  20. “Context cannot be used while the model is being created” exception with ASP.NET Identity
  21. Unable to find the requested .Net Framework Data Provider. It may not be installed
  22. Making a Simple Ajax call to controller in asp.net mvc
  23. Understanding WCF Windows Authentication
  24. Asp Net Web API 2.1 get client IP address
  25. Difference between MVC 5 Project and Web Api Project
  26. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  27. How to get rendered html (processed by Javascript) in WebBrowser control?
  28. Why does GetManifestResourceStream returns null while the resource name exists when calling GetManifestResourceNames?
  29. ‘No database provider has been configured for this DbContext’ on SignInManager.PasswordSignInAsync
  30. How can I ensure that appsettings.dev.json gets copied to the output folder?

Leave a Comment