public void AddClass() { ViewController vc = new ViewController(); //Ask for a student vc.ViewStudent(); WriteLine("\tChoose student"); Write("\tID: "); string s = ReadLine(); //Ask for a course vc.ViewCourse(); WriteLine("\tChoose course"); Write("\tID: "); string c = ReadLine(); //Add it to the database using (var data = new DbConnection()) { CoursesWithStudents cws = new CoursesWithStudents() { CourseID = c, StudentID = s }; data.CoursesWithStudents.Add(cws); data.SaveChanges(); WriteLine("\tSuccess!"); } }
// Data already in database. This code will fail, just for display purposes public static void CreateObjects() { using (var data = new DbConnection()) { var student1 = new Student { StudentID = "TEST", FirstName = "Herman", LastName = "Lippert" }; var student2 = new Student { StudentID = "TEST", FirstName = "Maria", LastName = "Skancke" }; var course1 = new Course { CourseID = "TEST", CourseName = ".NET" }; var course2 = new Course { CourseID = "TEST", CourseName = "OOP" }; var sAndc1 = new CoursesWithStudents { StudentID = student1.StudentID, CourseID = course1.CourseID }; var sAndc2 = new CoursesWithStudents { StudentID = student2.StudentID, CourseID = course2.CourseID }; data.Student.Add(student1); data.Student.Add(student2); //data.Course.Add(course1); //data.Course.Add(course2); data.CoursesWithStudents.Add(sAndc1); data.CoursesWithStudents.Add(sAndc2); data.SaveChanges(); } }