public static void FastVersion() { using (var telerikAcademy = new TelerikAcademyDB()) { telerikAcademy.Employees.Count(); var sw = new Stopwatch(); sw.Start(); var employees = telerikAcademy.Employees.Select(empl => empl.Address).Select(address => address.Town).Where(city => city.Name == "Sofia"); Console.WriteLine(sw.Elapsed); sw.Stop(); Console.WriteLine("Count of employees in Sofia: " + employees.Count()); } }
public static void WithoutInclude() { using (var telerikAcademy = new TelerikAcademyDB()) { telerikAcademy.Employees.Count(); Stopwatch sw = new Stopwatch(); sw.Start(); var employees = telerikAcademy.Employees; Console.WriteLine(sw.Elapsed); sw.Restart(); Console.WriteLine("Full Name\t Department Name\t Town Name"); foreach (var employee in telerikAcademy.Employees) { Console.WriteLine("{0} {1}\t {2}\t {3}", employee.FirstName, employee.LastName, employee.Department.Name, employee.Address.Town.Name); } Console.WriteLine(sw.Elapsed); } }