public static void PrintNamesWithLinqQuery() { SoftUniEntities db = new SoftUniEntities(); using (db) { var employees = db.Employees .Where(e => e.Projects.Any(p => p.StartDate.Year == 2002)) .OrderBy(e => e.FirstName) .Select(e => e.FirstName); foreach (var employee in employees) { Console.WriteLine(employee); } } }
public static void PrintNamesWithNativeQuery() { SoftUniEntities db = new SoftUniEntities(); using (db) { string query = "SELECT e.FirstName FROM Employees e " + "JOIN EmployeesProjects ep ON e.EmployeeID = ep.EmployeeID " + "JOIN Projects p ON ep.ProjectID = p.ProjectID " + "WHERE DATEPART(year, p.StartDate) = 2002"; var employees = db.Database.SqlQuery<string>(query); foreach (var employee in employees) { Console.WriteLine(employee); } } }