修改:
获取主键为3的这个员工信息
var emp = db.Employee.Find(3);
emp.EmpSalary = 7000;
linq
var emp = from e in db.Employee
where e.DeptId == 2
select e;
foreach (var item in emp)
{
item.EmpSalary += 800;
}
lambda
//lambda表达式
var emp = db.Employee.Where(e => e.EmpArea == "西安");
foreach (var item in emp)
{
item.EmpSalary += 90;
}
db.SaveChanges();
return RedirectToAction("Index");
}
删除:
var emp = db.Employee.Find(4);
db.Employee.Remove(emp);
linq
//linq
var emp = from e in db.Employee
where e.DeptId == 3
select e;
foreach (var item in emp)
{
db.Employee.Remove(item);
}
lambda
//lambda 表达式
var emp = db.Employee.Where(e => e.DeptId == 1);
foreach (var item in emp)
{
db.Employee.Remove(item);
}
每个后面都要家加上
db.SaveChanges();
return RedirectToAction("Index");