public static void SelectallEmployeesWithInclude(TelerikAcademyEntities context) { using (context) { foreach (var item in context.Employees.Include("Departments").Include("Adressess.Town")) { Console.WriteLine("Name {0}, Department {1}, Town {2}", item.FirstName, item.Department.Name, item.Address.Town.Name); } } }
public static void SelectAllEmployeesWithoutInclude(TelerikAcademyEntities context) { using (context) { foreach (var entity in context.Employees) { Console.WriteLine("Name {0}, Department {1}, Town {2}", entity.FirstName, entity.Department.Name, entity.Address.Town.Name); } } }
public static void SelectEmpInTown(TelerikAcademyEntities context, string town) { using (context) { // var employees = context.Employees.Where(x => x.Address.Town.Name == town); var employees = context.Employees .Select(e => e.Address) .Select(a => a.Town) .Where(t => t.Name == "Sofia") .ToList(); foreach (var employee in employees) { Console.WriteLine(employee.FirstName+" "+employee.LastName); } } }