private static void EmployeePrint(TelerikAcademyEntities context) { foreach (var employee in context.Employees) { Console.WriteLine("Employy: {0} {1} {2}, {3}, {4}", employee.FirstName, employee.MiddleName, employee.LastName, employee.Department.Name, employee.Address.Town.Name); } }
private static void SelectTown(TelerikAcademyEntities context, string city) { var towns = context.Employees.ToList().Select(e => e.Address).ToList().Select(a => a.Town).ToList().Where(t => t.Name == city); foreach (var town in towns) { Console.WriteLine(town.Name); } }
public static void Main() { TelerikAcademyEntities context = new TelerikAcademyEntities(); // 1300+ Records in Profiler, every 4 or smth is select so around 300 maybe EmployeePrint(context); // Around 180 Records in the Profiler, 36 selects only EmployeePrintWithInclude(context); // Again 1300+ Records :) string city = "Sofia"; SelectTown(context, city); // And the winer issssss : 1 query :) SelectTownFaster(context, city); }