Пример #1
0
        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}");
            }
        }
Пример #2
0
        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");
            }
        }