How can I retrieve Id of inserted entity using Entity framework? [closed]

by

It is pretty easy. If you are using DB generated Ids (like IDENTITY in MS SQL) you just need to add entity to ObjectSet and SaveChanges on related ObjectContext. Id will be automatically filled for you:

using (var context = new MyContext())
{
  context.MyEntities.Add(myNewObject);
  context.SaveChanges();

  int id = myNewObject.Id; // Yes it's here
}

Entity framework by default follows each INSERT with SELECT SCOPE_IDENTITY() when auto-generated Ids are used.

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. Entity Framework Timeouts
  5. Getting data from stored procedure with Entity Framework
  6. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  7. Entity Framework Refresh context? [closed]
  8. The instance of entity type cannot be tracked because another instance of this type with the same key is already being tracked
  9. The result of a query cannot be enumerated more than once
  10. Dynamic MySQL database connection for Entity Framework 6
  11. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  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. Determine if a number can be made with prepicked numbers and times
  23. Entity Framework change connection at runtime
  24. Convert System.Drawing.Color to RGB and Hex Value
  25. How to implement “Access-Control-Allow-Origin” header in asp.net
  26. How can I export a GridView.DataSource to a datatable or dataset?
  27. Easiest way to parse “querystring” formatted data
  28. ASP.NET File Upload
  29. GeneralLink in Sitecore
  30. Change cell color on different values – Gridview

Leave a Comment