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?
Object
after you call dc.SaveChanges();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;
}