DEV Community

Cover image for Get Id of recently added record in Linq.
bikashgosai
bikashgosai

Posted on

Get Id of recently added record in Linq.

After you commit your object into the db the object receives a value in its ID field.
So:

myObject.Field1 = "value";

// Db is the datacontext
db.MyObjects.InsertOnSubmit(myObject);
db.SubmitChanges();
//in case of Repository pattern
db.InsertorUpdate(myObject);
db.commit();

// You can retrieve the id from the object
int id = myObject.ID;
Enter fullscreen mode Exit fullscreen mode

Discussion (0)