private static void GetDepartmentAndManager() { var context = new SoftUniEntities(); var employees = context.Employees .Where(e => e.Manager != null) .OrderBy(d => d.Department.Name) .ThenBy(m => m.Manager.FirstName + " " + m.Manager.LastName) .ToList(); employees.ForEach(e => { Console.WriteLine("{0} Dep: {1}, Manager {2}", e.FirstName + " " + e.LastName, e.Department.Name, e.Manager.FirstName + " " + e.Manager.LastName); }); }
private static void GetDepartmentAndManager() { var context = new SoftUniEntities(); var employees = context.Employees .Where(e => e.Manager != null) .OrderBy(d => d.Department.Name) .ThenBy(m => m.Manager.FirstName + " " + m.Manager.LastName) .ToList(); employees.ForEach(e => { Console.WriteLine("{0} Dep: {1}, Manager {2}", e.FirstName + " " + e.LastName, e.Department.Name, e.Manager.FirstName + " " + e.Manager.LastName); }); }