I have the following scenario:
public void UpdateEmployee(int empId, int deptId, int level)
{
Employee emp = GetEmployee(empId);
emp.DeptId = deptId;
emp.Level = level;
using (var mye = new MyEntity())
{
//this is having no effect?
wc.SaveChanges()
}
}
I'm not sure how to save the Employee object update back to the database. The employee does exist in the database. What should go in the using block?
Attach it before modifying, modify, then save changes.
public void UpdateEmployee(int empId, int deptId, int level)
{
Employee emp = GetEmployee(empId);
using (var dbContext = new MyDbContext())
{
dbContext.Employees.Attach(emp);
emp.DeptId = deptId;
emp.Level = level;
//this is having no effect?
dbContext.SaveChanges()
}
}
You could also attach it, and then set the state to Modified:
public void UpdateEmployee(int empId, int deptId, int level)
{
Employee emp = GetEmployee(empId);
emp.DeptId = deptId;
emp.Level = level;
using (var dbContext = new MyDbContext())
{
dbContext.Employees.Attach(emp);
dbContext.Entry(emp).State = EntityState.Modified;
dbContext.SaveChanges()
}
}
And if you only want to send those fields in the update instead of all columns:
public void UpdateEmployee(int empId, int deptId, int level)
{
Employee emp = GetEmployee(empId);
emp.DeptId = deptId;
emp.Level = level;
using (var dbContext = new MyDbContext())
{
dbContext.Employees.Attach(emp);
dbContext.Entry(emp).Property(p => p.DeptId).IsModified = true;
dbContext.Entry(emp).Property(p => p.Level).IsModified = true;
dbContext.SaveChanges()
}
}
You need to call SaveChanges on your ObjectContext
GetEmployeemethod work ? are you sure it returns the correct result?