コード例 #1
0
        public static void DeleteEmp()
        {
            EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1();

            var employees = context.Employees;
            var Employee  = new Employee {
                EmpID = 4
            };

            employees.Attach(Employee);
            employees.Remove(Employee);
            context.SaveChanges();
        }
コード例 #2
0
        public static void ModifiyEmp()
        {
            EmployeeEFDBEntities1 context = new EmployeeEFDBEntities1();

            var employees = context.Employees;

            var emplist = from Employee in employees
                          orderby Employee.EmpID
                          select Employee;

            foreach (var employee in emplist)
            {
                if (employee.EmpID == 1)
                {
                    employee.SSN = 99;
                }
            }
            context.SaveChanges();
        }