public static void FastToListOperation() { using (TelerikAcademyEntities context = new TelerikAcademyEntities()) { Stopwatch watch = new Stopwatch(); watch.Start(); var sofiaEmployees = context.Employees.Select(e => e).Select(e => e.Address).Select(a => a.Town) .Where(t => t.Name.ToLower() == "sofia"); Console.WriteLine("Sofia employee count = {0}.", sofiaEmployees.Count()); watch.Stop(); Console.WriteLine("Fast operations executed in {0} milliseconds.", watch.Elapsed.Milliseconds); } }
public static void FastEmployeeQuery() { using (TelerikAcademyEntities context = new TelerikAcademyEntities()) { Stopwatch watch = new Stopwatch(); watch.Start(); var employees = from employee in context.Employees.Include("Department").Include("Address").Include("Town") select new { Name = employee.LastName, Department = employee.Department.Name, Town = employee.Address.Town.Name }; /*foreach (var employee in employees) { Console.WriteLine("{0} from department {1} lives in {2}.", employee.Name, employee.Department, employee.Town); }*/ watch.Stop(); Console.WriteLine("Fast operations executed in {0} milliseconds.", watch.Elapsed.Milliseconds); } }