private static void ReadData() { using (var context = new Employees.employeesContext()) { DateTime dateTime = new DateTime(2001, 01, 01); var orderedQueryable = from e in context.Employees join s in context.Salaries on e.EmpNo equals s.EmpNo where s.FromDate >= dateTime group s by e.EmpNo into salaryGroup select new { EmployeeId = salaryGroup.Key, AvgSalary = salaryGroup.Average(x => x.Salary) }; foreach (var message in from result in orderedQueryable.OrderByDescending((x) => x.AvgSalary) let message = new StringBuilder() .AppendLine($"EmployeeID: {result.EmployeeId}, AvgSalary: {result.AvgSalary}") select message) { Console.WriteLine(message.ToString()); } } }
private static List <salaryGroupData> CommonSQLWhere() { using (var context = new Employees.employeesContext()) { DateTime dateTime = new DateTime(2001, 01, 01); var orderedQueryable = from e in context.Employees join s in context.Salaries on e.EmpNo equals s.EmpNo where s.FromDate >= dateTime select new salaryGroupData { EmployeeId = e.EmpNo, SalaryCalculation = s.Salary }; return(orderedQueryable.ToList()); } }