Get Auto Identity Key after Insert via EF
dbcontext, entity-framework, entity-framework-4.1
Solution
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;
Problem
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