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

c# entity-framework

Question

I am inserting into the database through the "AddObject(Object)" method and I wanted to get the last inserted id of that so i could insert into another table with that last created id. How would I go about doing that? Is the best way of doing this? or is there better way?

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 available in Object after you call dc.SaveChanges();
  2. Another way it's use Guid or some else id that you can generate yourself.
13
3/18/2011 9:43:01 AM

Popular Answer

See the code sample as below:

 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 ()

im using poco code first . how do i get the last insert 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

Yes of course you can do this. See example:...int id = 0; using (PC2Entities objectContext = new PC2Entities()) { objectContext.ClientContacts.AddObject(clientContact); objectContext.SaveChanges(); id = clientContact.Id; transaction.Complete(); } ...id... is the PK.
.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 prevent error you'll need to ensure that the id you're checking on is of an actual ...Item.... Something like this, for example:...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 simply sort in descending order and get the first item....var myFormsAtStep1 = context.MyForms.Include("AuditItems").Where( mf => mf.AuditItems.OrderByDescending( ai => ai.DateOfAction).First().Step == 1); ...I would also use the query syntax, which would be more readable, as well as the strongly-typed Include (import Sy...
c# entity-framework linq linq-to-entities
asked by CMircea

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

I'm working with ...EF6 code first... in a ...WinForm... project. I used following method for reading entities from ...Db..., updating them and then save back them to ...Db...:...Read Entity graph using ...Linq to entities...(after reading the ...DbContext... disposes)...Show readed ...Entity... graph to end user....End user may apply this changes ...
c# ef-code-first entity-framework graphdiff repository
asked by Masoud

How to get Last Inserted ID if using Entity Framework

What if you needed to insert into a table without triggering validation on the models used to insert into the table? IE in the DB a field is not required and an insert of null would work, but in the EF Model it is a required field?
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 MVC 5, EF 6, Oracle, and database first. I'm trying to auto-generate the ID of an object called Mission. Currently in the database there is a stored procedure which does this by using a sequence, MISSION_SEQ, on the insert command. I'm having trouble getting this stored procedure to work, so I thought I could try to handle it myself like this...
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

I want to bulk insert 100,000+ rows into a table (which has a identity column which auto increments every time a new row is inserted)....What would be the fastest way to insert the rows with least performance impact?...After all rows are inserted, how do I get the list of ids of the rows that are recently inserted?...Note: I did the following but I...
c# entity-framework entity-framework-6 sql
asked by user3861992

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

I am trying to use EF to export/import the existing database of a DbContext. In this context, there are several entities with Guid Id properties with DatabaseGeneratedOption.Identity defined by the ModelBuilder. When I re-import the entities, I want to use the Id value from the serialized object, but it always generates a new Id value when I save t...
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

SQL Server table T2 has 2 columns:...Id INT NOT NULL CreateDate DateTime NOT NULL, default = (getdate()) ...This statement inserts the CreateDate value correctly because it uses (getdate()) as default. ...Insert T2 (Id) Values (1) ...So far so good. The problem is when I use Entity Framework to insert a row and still wish to use the default (...ge...
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