In Linq EF, how do I retrieve the latest entered id?

c# entity-framework

Question

I needed to know the latest generated id of an object I was adding to the database using the "AddObject(Object)" function so I could add it to another table. What would be the best way to achieve that? Is this the best approach? or is there an alternative?

1
9
3/18/2011 10:37:45 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

  1. Id will be offered inObject after the call to dc.SaveChanges();
  2. Use Guid or any ID that you create on your own is another option.
13
3/18/2011 9:43:01 AM

Popular Answer

See the following code sample:

 public virtual int CreateNewEmployee(Employee newEmployee)
        {
            if (newEmployee.EntityState == EntityState.Detached)
                _DatabaseContext.Employees.Attach(newEmployee);

            _DatabaseContext.ObjectStateManager.ChangeObjectState(newEmployee, EntityState.Added);

            int numberOfAffectedRows = _DatabaseContext.SaveChanges();

            return newEmployee.EmployeeId;
        }
Ashraf Alam

Related Questions

Savechanges returns the latest insert id to asp mvc ()

I'm starting with poco coding. What was the most recent insert made after savechanges()?...thanks
asp.net asp.net-mvc-3 entity-framework linq sql
asked by colorblack04

Getting the primary key ID for an added entry in Entity Framework 4

You can do this, of course. see illustration...int id = 0; using (PC2Entities objectContext = new PC2Entities()) { objectContext.ClientContacts.AddObject(clientContact); objectContext.SaveChanges(); id = clientContact.Id; transaction.Complete(); } ...id... The PK is.
.net c# entity-framework
asked by asma

Delete From DataContext Using ID == ID with a simple LINQ query

DataContext.Items.DeleteObject((Item)DataContext.Items.Where(item => item.ItemId == selectedId).First()); ...Don't forget to make sure the ID you are verifying belongs to a real person in order to avoid mistake....Item... . Consider something like this:...var item = (Item)DataContext.Items.Where(item => item.ItemId == selectedId).FirstOrDefault(); ...
c# entity-framework linq
asked by doctorless

LINQ Lambda: Getting Last item (where == ) of sub collection

You just receive the first item after sorting in decreasing order....var myFormsAtStep1 = context.MyForms.Include("AuditItems").Where( mf => mf.AuditItems.OrderByDescending( ai => ai.DateOfAction).First().Step == 1); ...The query syntax, which is more legible, and the strongly-typed Include (import System.Data.Entity) are bo...
c# entity-framework linq linq-to-entities
asked by CMircea

Update entity graph Ids with Db generated Ids in Disconnected environment(EF)

ZZZ_tmp
c# ef-code-first entity-framework graphdiff repository
asked by Masoud

How to get Last Inserted ID if using Entity Framework

ZZZ_tmp
asp.net-mvc-3 entity-framework
asked by Justin Maynard

MVC EF Oracle: How do I use a sequence to generate the next ID on insert?

using Oracle, MVC 5, EF 6, and the database first. I'm attempting to have an object named Mission's ID generated automatically. Currently, a stored procedure in the database uses the insert command and the sequence MISSION SEQ to do this. Since I'm having difficulties getting this stored procedure to function, I decided to try handling it myself as...
asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6 oracle
asked by Michael Kubala

Bulk insert records and get their Id's after bulk insert in Entity Framework

ZZZ_tmp
c# entity-framework entity-framework-6 sql
asked by user3861992

EF6 entity with DatabaseGeneratedOption.Identity Guid Id force insert my Id value

ZZZ_tmp
c# code-first database entity-framework entity-framework-6
asked by Andy Clark

EF - pass null value to SQL column so default value gets inserted

Table T2 in SQL Server contains two columns:...Id INT NOT NULL CreateDate DateTime NOT NULL, default = (getdate()) ...Because it utilises (getdate()) by default, this line successfully adds the CreateDate value....Insert T2 (Id) Values (1) ...All is OK thus far. Using Entity Framework to enter a row but still wanting to utilise the default (...get...
entity-framework-6 sql-server
asked by nanonerd

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow