public IActionResult StudentsCoursesWithA() { ViewData["Title"] = "Students and Courses with A"; var students = _repo.ReadAllStudents(); var studentGrades = _repo.ReadAllStudentGrades(); /* * var query = students * .Join( * studentGrades, * s => s.ENumber, * sg => sg.StudentENumber, * (s, sg) => new { Student = s, StudentGrade = sg }) * .Where(sc => sc.StudentGrade.LetterGrade == "A") * .Select(sc => new StudentCourseVM * { * LastName = sc.Student.LastName, * CourseCode = sc.StudentGrade.CourseCode, * CourseNumber = sc.StudentGrade.CourseNumber * }); */ var query = from s in students join sg in studentGrades on s.ENumber equals sg.StudentENumber where sg.LetterGrade == "A" select new StudentCourseVM { LastName = sg.Student.LastName, CourseCode = sg.CourseCode, CourseNumber = sg.CourseNumber }; var model = query.ToList(); return(View(model)); }