Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static void DepWithMoreThan5Emp()
- {
- using (var context = new SoftUniContext())
- {
- var departments = context.Departments
- .Where(x => x.Employees.Count > 5)
- .OrderBy(x => x.Employees.Count);
- foreach (var d in departments)
- {
- Console.WriteLine($"{d.Name} {d.Employee.FirstName}");
- foreach (var e in d.Employees.OrderBy(e => e.EmployeeID))
- {
- Console.WriteLine($"{e.FirstName} {e.LastName} {e.JobTitle}");
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement