private static void DropRegistration(string studentNum, string courseCode)// b. { using (SRS1179Entities db = new SRS1179Entities()) { Student s = db.Students.Where(st => st.StudentNum == studentNum).First(); Course c = db.Courses.Where(cr => cr.CourseCode == courseCode).First(); s.Courses.Remove(c); db.SaveChanges(); Console.WriteLine($"Registration dropped: {s.FirstName} -> {c.CourseName}"); } }
private static void DropAllCourseRegistrations()// f. { using (SRS1179Entities db = new SRS1179Entities()) { List <Course> courses = db.Courses.ToList(); foreach (Course c in courses) { c.Students.Clear(); } db.SaveChanges(); Console.WriteLine("All course registrations dropped"); } }