Get Auto Identity Key after Insert via EF

Question

Is there a straight forward way of retrieving a DB auto generated primary key when adding a record via Entity Framework 4.1?

For example:

dbcontext.Entity_Tables.Add(new Entity_Table { item1 = val1, item2 = val2 }); dbcontext.SaveChanges(); newPK = ???;

The SQL equivalent would be:

newPK = executeOnDB("INSERT INTO Entity_Table (item1, item2) VALUES (val1, val2);SELECT @@Indentity";);

BTW I'm using MySQL but the SQL would be the same as on MSSQL

I just want to point out that SELECT @@Identity is NOT a good way to get the last inserted id. You should use SCOPE_IDENTITY() — Icarus
– Icarus, Commented Dec 8, 2011 at 18:06
Thanks Icarus. I never realized that. Guess I should update some of my older apps too! — chrisg229
– chrisg229, Commented Dec 8, 2011 at 18:10
Possible duplicate of How can I get Id of inserted entity in Entity framework? — Michael Freidgeim
– Michael Freidgeim, Commented Jun 14, 2016 at 2:01

Omer Bokhari · Accepted Answer · 2011-12-08 18:08:38Z

96

I believe EF should update your entity object with the identity:

var entity = new Entity_Table { item1 = val1, item2 = val2 }; dbcontext.Entity_Tables.Add(entity); dbcontext.SaveChanges(); int newPK = entity.ID;

answered Dec 8, 2011 at 18:08

Omer Bokhari

60k12 gold badges46 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

chrisg229 Over a year ago

I just confirmed that's exactly what it does. Many thanks ob!

Mahesh Over a year ago

When I insert, there is an InsertBefore trigger on the table which adds its own properties, and so, even if save changes is executing, that insert is replaced by the insert before, and so, the ID returned for me is 0, and the actual value of ID is something else. In that case how do i get the value?

Revathi Vijay Over a year ago

How to get Auto Identity Key before Insert via EF?

Pratik 1020 Over a year ago

Guess this is before save changes then how to refetch only ID int newPK = entity.ID;

Collectives™ on Stack Overflow

Get Auto Identity Key after Insert via EF

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related