Devart Forums

Code: Select all

            // Fetch and print the employees
            IList employeeList = null;
            using (EmployeesDataContext db = new EmployeesDataContext())
            {
                var employees = from e in db.Employees
                                where e.FirstName == "Nathan" && e.LastName.StartsWith("Pa")
                                select e;
                employeeList = employees.ToList();
                foreach (var employee in employeeList)
                {
                    Console.WriteLine("Employee: {0} {1}, DOB: {2}",
                        employee.FirstName, employee.LastName, employee.BirthDate);
                }
            }
            Console.WriteLine();

            // Modify the list out of a context
            foreach (var employee in employeeList)
            {
                employee.BirthDate = employee.BirthDate.AddYears(10);
                Console.WriteLine("Employee: {0} {1}, DOB: {2}",
                    employee.FirstName, employee.LastName, employee.BirthDate);
            }

            // Re-attach and save the mofifications
            using (EmployeesDataContext db = new EmployeesDataContext())
            {
                db.Employees.AttachAll(employeeList, true);
                db.SubmitChanges();
            }