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

Opteamix Recognized as a "Dream Company" to Work for by World HRD Congress
The 25th World HRD Congress in association with Times Ascent recognized Opteamix as a Dream Company ...
Shop CJ Strays from the Bold Talk, Engages with the Beautiful
A woman’s essence lies in her inherent ability to care, love and sacrifice for others. Celebrating t...
CG Announces Sale of B2B Automation Business to Alfanar
Avantha Group Company, CG Power and Industrial Solutions Limited (Formerly Crompton Greaves Limited)...