gistfile1.cs

 public IQueryable<CoursesBySectionViewModel> GetCoursesBySection()
        {
            return from cs in this.courseSectionRepository.GetAll()
                   join staffmem in staffRepository.GetAll() on cs.CourseSectionID equals staffmem.CourseSectionID
                    
                   select new CoursesBySectionViewModel
                   {
                       AcademicYearId = cs.AcademicYearID,
                       SchoolId = cs.SchoolID,
                       CourseSectionId = cs.CourseSectionID,
                       SectionName = cs.CourseSectionDescription,
                       GradeLevelId = cs.GradeLevelID,
                       GradeLevelName = cs.GradeLevelID.ToString(),
                       SectionNumber = cs.GradeLevelID + "A"
                   };

            //return this.courseSectionRepository.GetAll().Project().To<CoursesBySectionViewModel>();
        }
        
        // you can also use the automapper technique as well, then you need simpler expressions such as 
        
        return this.courseSectionRepository.GetAll().Project().To<CoursesBySectionViewModel>();