Question
I am inserting into the database through the "AddObject(Object)" method and I wanted to get the last inserted id of that so i could insert into another table with that last created id. How would I go about doing that? Is the best way of doing this? or is there better way?
Accepted Answer
- Id will be available in
Objectafter you call dc.SaveChanges(); - Another way it's use Guid or some else id that you can generate yourself.
Popular Answer
See the code sample as below:
public virtual int CreateNewEmployee(Employee newEmployee)
{
if (newEmployee.EntityState == EntityState.Detached)
_DatabaseContext.Employees.Attach(newEmployee);
_DatabaseContext.ObjectStateManager.ChangeObjectState(newEmployee, EntityState.Added);
int numberOfAffectedRows = _DatabaseContext.SaveChanges();
return newEmployee.EmployeeId;
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
