How to return the ID field after the insert in Entity Framework ?

There are times when you want to retrieve the ID of the last inserted record when using Entity Framework .

For example ,

Employee emp = new Employee();

emp.ID = -1;

emp.Name = "Senthil Kumar B";

emp.Expertise = "ASP.NET MVC"

EmployeeContext context = new EmployeeContext();

context.AddObject(emp);

context.SaveChanges();

In the above example , if i need to retrieve the ID of the employee that was inserted , all that i need to do is use the emp.ID property once the data is saved as shown below.

Employee emp = new Employee();

emp.ID = -1;

emp.Name = "Senthil Kumar B";

emp.Expertise = "ASP.NET MVC"

EmployeeContext context = new EmployeeContext();

context.AddObject(emp);

context.SaveChanges();

int empID = emp.ID;
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

Takeda Appoints Toshio Fujimoto, MD, MBA, as General Manager of the Health Innovation Park in Shonan
Osaka, JapanTakeda Pharmaceutical Company Limited announced that Toshio Fujimoto, MD, MBA has been a...
Artemis Hospital Becomes First in India to Adopt Masimo Patient SafetyNet™ Across All Hospital Care Areas
Masimo (NASDAQ: MASI) announced that Artemis Hospital, one of the leading multi-specialty hospitals ...
Rockwell Automation Acquires Odos Imaging to Leverage 3-D Time-of-Flight Technology for Sensing and Safety Applications
Rockwell Automation, Inc. (NYSE: ROK) has acquired Odos Imaging, a Scottish technology company that ...