public static bool IsEnrolled(int studentId, int subjectId) { using (var db = new DerpUniversityDataContext()) { var student = db.Students.First(s => s.Id == studentId); return student.StudentSubjectEnrolments.Any(sse => sse.SubjectId == subjectId); } }
/// <summary> /// Searches for a student by name. /// </summary> /// <param name="name">Any Part of the first name or last name of the student.</param> /// <returns></returns> public static Student[] SearchStudents(string name) { using (var db = new DerpUniversityDataContext()) { var students = db.Students .Where(s => s.LastName.Contains(name)) .ToArray(); return students; } }
public static Subject[] GetStudentEnrolments(int id) { using (var db = new DerpUniversityDataContext()) { var subjects = db.Students .First(s => s.Id == id) .StudentSubjectEnrolments .Select(sse => sse.Subject) .ToArray(); return subjects; } }