public void Save() { context.SaveChanges(); }
public static void Initialize(SchoolContext context) { // context.Database.EnsureCreated(); // Look for any students if (context.Students.Any()) { return; // DB has already been created } var students = new Student[] { new Student { FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2010-09-01") }, new Student { FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2011-09-01") }, new Student { FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstMidName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstMidName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new Department { Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); var courses = new Course[] { new Course { CourseID = 1050, Title = "Chemistry", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID }, new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 1045, Title = "Calculus", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 2021, Title = "Composition", Credits = 3, DepartmentID = departments.Single(s => s.Name == "English").DepartmentID }, new Course { CourseID = 2042, Title = "Literature", Credits = 4, DepartmentID = departments.Single(s => s.Name == "English").DepartmentID }, }; foreach (Course c in courses) { context.Courses.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID, Location = "Smith 17" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Harui").ID, Location = "Gowan 27" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID, Location = "Thompson 304" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Zheng").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Zheng").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Composition").CourseID, InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Literature").CourseID, InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alexander").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Alonso").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anand").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Barzdukas").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Li").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Justice").ID, CourseID = courses.Single(c => c.Title == "Literature").CourseID, Grade = Grade.B } }; foreach (Enrollment e in enrollments) { var enrollmentInDataBase = context.Enrollments.Where( s => s.Student.ID == e.StudentID && s.Course.CourseID == e.CourseID).SingleOrDefault(); if (enrollmentInDataBase == null) { context.Enrollments.Add(e); } } context.SaveChanges(); }
public static void Initialize(SchoolContext context) { context.Database.EnsureCreated(); if (context.Student.Any()) { return; } var students = new Student[] { new Student { FirstMidName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2005-09-01") }, new Student { FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2002-09-01") }, new Student { FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2001-09-01") }, new Student { FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2003-09-01") }, new Student { FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2005-09-01") } }; foreach (Student s in students) { context.Student.Add(s); } context.SaveChanges(); var courses = new Course[] { new Course { CourseID = 1050, Title = "Chemistry", Credits = 3 }, new Course { CourseID = 4022, Title = "Microeconomics", Credits = 3 }, new Course { CourseID = 4041, Title = "Macroeconomics", Credits = 3 }, new Course { CourseID = 1045, Title = "Calculus", Credits = 4 }, new Course { CourseID = 3141, Title = "Trigonometry", Credits = 4 }, new Course { CourseID = 2021, Title = "Composition", Credits = 3 }, new Course { CourseID = 2042, Title = "Literature", Credits = 4 } }; foreach (Course c in courses) { context.Course.Add(c); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = 1, CourseID = 1050, Grade = Grade.A }, new Enrollment { StudentID = 1, CourseID = 4022, Grade = Grade.C }, new Enrollment { StudentID = 1, CourseID = 4041, Grade = Grade.B }, new Enrollment { StudentID = 2, CourseID = 1045, Grade = Grade.B }, new Enrollment { StudentID = 2, CourseID = 3141, Grade = Grade.F }, new Enrollment { StudentID = 2, CourseID = 2021, Grade = Grade.F }, new Enrollment { StudentID = 3, CourseID = 1050 }, new Enrollment { StudentID = 4, CourseID = 1050 }, new Enrollment { StudentID = 4, CourseID = 4022, Grade = Grade.F }, new Enrollment { StudentID = 5, CourseID = 4041, Grade = Grade.C }, new Enrollment { StudentID = 6, CourseID = 1045 }, new Enrollment { StudentID = 7, CourseID = 3141, Grade = Grade.A }, }; foreach (Enrollment e in enrollments) { context.Enrollment.Add(e); } context.SaveChanges(); }
public static void Initialize(SchoolContext context) { // Look for any students. if (context.Facultys.Any()) { return; // DB has been seeded } else { var faculties = new Faculty[] { new Faculty { Name = "Engineering and Computer Science", StartDate = DateTime.Parse("2000-01-01") }, new Faculty { Name = "John Molson School of Business", StartDate = DateTime.Parse("2000-01-01") }, new Faculty { Name = "Arts and Science", StartDate = DateTime.Parse("2000-01-01") }, new Faculty { Name = "Fine Arts", StartDate = DateTime.Parse("2000-01-01") } }; foreach (Faculty d in faculties) { context.Facultys.Add(d); } context.SaveChanges(); } // var students = new Student[] // { // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Carson", LastName = "Alexander", Program = "BComp"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Meredith", LastName = "Alonso", Program = "BEng"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Arturo", LastName = "Anand", Program = "BEng"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Gytis", LastName = "Barzdukas", Program = "BComp"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Yan", LastName = "Li", Program = "BEng"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Peggy", LastName = "Justice", Program = "BComp"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Laura", LastName = "Norman", Program = "BCSA"}, // new Student {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Nino", LastName = "Olivetto", Program = "BCSA"} // }; // foreach (Student s in students) // { // context.Students.Add(s); // } // context.SaveChanges(); // var professors = new Professor[] // { // new Professor {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Kim", LastName = "Abercrombie", // HireDate = DateTime.Parse("1995-03-11") }, // new Professor {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Fadi", LastName = "Fakhouri", // HireDate = DateTime.Parse("2002-07-06") }, // new Professor {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Roger", LastName = "Harui", // HireDate = DateTime.Parse("1998-07-01") }, // new Professor {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Candace", LastName = "Kapoor", // HireDate = DateTime.Parse("2001-01-15") }, // new Professor {UserName = "******", // Email = "*****@*****.**", FirstMidName = "Roger", LastName = "Zheng", // HireDate = DateTime.Parse("2004-02-12") } // }; // foreach (Professor i in professors) // { // context.Professors.Add(i); // } // context.SaveChanges(); // var departments = new Department[] // { // new Department { Name = "English", // StartDate = DateTime.Parse("2007-09-01"), // FacultyID = faculties.Single(i => i.Name == ("Arts and Science")).FacultyID, // ProfessorID = professors.Single( i => i.LastName == "Abercrombie").Id }, // new Department { Name = "Mathematics", // StartDate = DateTime.Parse("2007-09-01"), // FacultyID = faculties.Single(i => i.Name == ("Engineering and Computer Science")).FacultyID, // ProfessorID = professors.Single( i => i.LastName == "Fakhouri").Id }, // new Department { Name = "Engineering", // StartDate = DateTime.Parse("2007-09-01"), // FacultyID = faculties.Single(i => i.Name == ("Engineering and Computer Science")).FacultyID, // ProfessorID = professors.Single( i => i.LastName == "Harui").Id }, // new Department { Name = "Economics", // StartDate = DateTime.Parse("2007-09-01"), // FacultyID = faculties.Single(i => i.Name == ("John Molson School of Business")).FacultyID, // ProfessorID = professors.Single( i => i.LastName == "Kapoor").Id } // }; // foreach (Department d in departments) // { // context.Departments.Add(d); // } // context.SaveChanges(); // var courses = new Course[] // { // new Course {CourseID = 1050, Title = "Chemistry", Credits = 3, // DepartmentID = departments.Single( s => s.Name == "Engineering").DepartmentID // }, // new Course {CourseID = 4022, Title = "Microeconomics", Credits = 3, // DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID // }, // new Course {CourseID = 4041, Title = "Macroeconomics", Credits = 3, // DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID // }, // new Course {CourseID = 1045, Title = "Calculus", Credits = 4, // DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID // }, // new Course {CourseID = 3141, Title = "Trigonometry", Credits = 4, // DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID // }, // new Course {CourseID = 2021, Title = "Composition", Credits = 3, // DepartmentID = departments.Single( s => s.Name == "English").DepartmentID // }, // new Course {CourseID = 2042, Title = "Literature", Credits = 4, // DepartmentID = departments.Single( s => s.Name == "English").DepartmentID // }, // }; // foreach (Course c in courses) // { // context.Courses.Add(c); // } // context.SaveChanges(); // var officeAssignments = new OfficeAssignment[] // { // new OfficeAssignment { // ProfessorID = professors.Single( i => i.LastName == "Fakhouri").Id, // Location = "Smith 17" }, // new OfficeAssignment { // ProfessorID = professors.Single( i => i.LastName == "Harui").Id, // Location = "Gowan 27" }, // new OfficeAssignment { // ProfessorID = professors.Single( i => i.LastName == "Kapoor").Id, // Location = "Thompson 304" }, // }; // foreach (OfficeAssignment o in officeAssignments) // { // context.OfficeAssignments.Add(o); // } // context.SaveChanges(); // int id = 10; // var courseInstructors = new CourseAssignment[] // { // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Kapoor").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Harui").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Zheng").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Zheng").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Fakhouri").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Harui").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Composition" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Abercrombie").Id, // SemesterID = id // }, // new CourseAssignment { // CourseID = courses.Single(c => c.Title == "Literature" ).CourseID, // ProfessorID = professors.Single(i => i.LastName == "Abercrombie").Id, // SemesterID = id // }, // }; // foreach (CourseAssignment ci in courseInstructors) // { // context.CourseAssignments.Add(ci); // } // context.SaveChanges(); // var enrollments = new Enrollment[] // { // new Enrollment { // SmID = students.Single(s => s.LastName == "Alexander").Id, // CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID, // Grade = Grade.A // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Alexander").Id, // CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID, // Grade = Grade.C // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Alexander").Id, // CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Alonso").Id, // CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Alonso").Id, // CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Alonso").Id, // CourseID = courses.Single(c => c.Title == "Composition" ).CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Anand").Id, // CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Anand").Id, // CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Barzdukas").Id, // CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Li").Id, // CourseID = courses.Single(c => c.Title == "Composition").CourseID, // Grade = Grade.B // }, // new Enrollment { // SmID = students.Single(s => s.LastName == "Justice").Id, // CourseID = courses.Single(c => c.Title == "Literature").CourseID, // Grade = Grade.B // } // }; // foreach (Enrollment e in enrollments) // { // var enrollmentInDataBase = context.Enrollments.Where( // s => // s.Student.Id == e.SmID && // s.Course.CourseID == e.CourseID).SingleOrDefault(); // if (enrollmentInDataBase == null) // { // context.Enrollments.Add(e); // } // } // context.SaveChanges(); }