Asp.Net - MVC-6.使用linq、lambda测试修改、删除

修改：

            获取主键为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");