EF - SomeEFActionsClass

using System;
using System.Linq;

namespace SomeEFActionsClass
{
    class SomeEFActionsClass
    {
        static void Main(string[] args)
        {
            // Problem 3.   Employees with Projects after 2002
            Console.WriteLine("----- Problem 3. Employees with Projects after 2002 -----");
            var softUniEntities = new SoftUniEntities();
            var employeesWithProjectsAfter2012 = (softUniEntities.Employees
                .Where(
                    e =>
                    DateTime.Compare(e.HireDate, new DateTime(2002, 1, 1)) > 0
                )).ToList();

            int employeesCount = 1;

            foreach (var employee in employeesWithProjectsAfter2012)
            {
                Console.WriteLine(employeesCount + " " + employee.FirstName + " " + employee.LastName +
                    ", HireDate: " + employee.HireDate);
                employeesCount++;
            }

            // Problem 4.   Native SQL Query
            Console.WriteLine("----- Problem 4. previous task by using native SQL query  -----");
            var context = new SoftUniEntities();
            string nativeSQLQuery =
                "SELECT FirstName + ' ' + LastName + ' ' + CONVERT(VARCHAR(24), HireDate, 113) " +
                "FROM dbo.Employees WHERE HireDate > {0}";
            var employees = context.Database.SqlQuery<string>(nativeSQLQuery, "01-jan-2002");
            int employeesCount2 = 1;

            foreach (var emp in employees)
            {
                Console.WriteLine(employeesCount2 + " " + emp);
                employeesCount2++;
            }

            // Problem 5.   Employees by Department and Manager [Example Usage]
            var employeesByDepartmentAndManager = EmployeesByDepartmentAndManager("Production", "Jo Brown");
            Console.WriteLine("----- 05. Employees by Department and Manager -----");
            foreach (var emp in employeesByDepartmentAndManager)
            {
                Console.WriteLine(emp.FirstName + " " + emp.LastName);
            }
        }

        // Problem 5.   Employees by Department and Manager
        public static IQueryable<Employee> EmployeesByDepartmentAndManager(string departmentName, string managerFullName)
        {
            var softUniEntities = new SoftUniEntities();
            //IQueryable<Employee> employyes = softUniEntities.Employees
            //    .Where((e => e.Department == departmentName)
            IQueryable<Employee> employees = softUniEntities.Employees
                            .Where(e => e.Department.Name == departmentName &&
                            e.Employee1.FirstName + " " + e.Employee1.LastName == managerFullName);

            return employees;
        }
    }
}