public static Class GetCourseTitle(String course) { ClassInfoEntities context = new ClassInfoEntities(); var courseTitle = (from c in context.Classes where c.ClassNumber.Equals(course) select c).Single(); return(courseTitle); }
public static List <Class> GetAllCourses() { ClassInfoEntities context = new ClassInfoEntities(); List <Class> allCourses = (from c in context.Classes select c).ToList(); return(allCourses); }
public static Instructor GetTeacherOffice(String course) { ClassInfoEntities context = new ClassInfoEntities(); var OfficeLocation = (from c in context.Classes join t in context.Instructors on c.InstID equals t.InstID where c.ClassNumber.Equals(course) select t).Single(); return(OfficeLocation); }
public static List <Student> GetAllStudents(String course) { ClassInfoEntities context = new ClassInfoEntities(); ////var AllStudents = // (from StudentList in context.Students // where StudentList.Classes.Contains(course) // select StudentList); //var StudentsInCourse = // (from student in AllStudents // where student. // ) var AllStudents = ( from c in context.Classes where c.ClassNumber == course select c.Students ).Single().ToList(); return(AllStudents); }