public static void Initialize(ContosoUniversityContext context) { //context.Database.EnsureCreated(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstName = "Carson", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2010-09-01") }, new Student { FirstName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2011-09-01") }, new Student { FirstName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstName = "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 { FirstName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstName = "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.Students.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.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 }, 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.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" }, }; var courseInstrucotrs = 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 ca in courseInstrucotrs) { context.CourseAssignments.Add(ca); } 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.Enrollments.Add(e); } context.SaveChanges(); }
public static void Initialize(SchoolContext context) { bool isDatabaseAllreadySeeded = context.Students.Any() && context.Courses.Any() && context.Enrollments.Any(); // Look for any students. if (isDatabaseAllreadySeeded) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Emma", LastName = "Anderson", EnrollmentDate = DateTime.Parse("2020-08-10") }, new Student { FirstMidName = "Martin", LastName = "Petrov", EnrollmentDate = DateTime.Parse("2019-08-10") }, new Student { FirstMidName = "Victoria", LastName = "Kancheva", EnrollmentDate = DateTime.Parse("2019-08-10") }, new Student { FirstMidName = "Kris", LastName = "Kanchev", EnrollmentDate = DateTime.Parse("2020-08-10") }, new Student { FirstMidName = "Todor", LastName = "Todorov", EnrollmentDate = DateTime.Parse("2019-08-10") }, new Student { FirstMidName = "Isabella", LastName = "Morison", EnrollmentDate = DateTime.Parse("2020-08-10") }, new Student { FirstMidName = "Alexander", LastName = "Konstantinov", EnrollmentDate = DateTime.Parse("2020-08-10") }, new Student { FirstMidName = "Cvetelina", LastName = "Aleksieva", EnrollmentDate = DateTime.Parse("2019-08-10") } }; context.Students.AddRange(students); context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstMidName = "Alexander", LastName = "Trifonov", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstMidName = "Radostin", LastName = "Raikov", HireDate = DateTime.Parse("1990-02-22") }, new Instructor { FirstMidName = "Kristiqn", LastName = "Vachkov", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstMidName = "Gabriel", LastName = "Atanasov", HireDate = DateTime.Parse("2001-11-15") }, new Instructor { FirstMidName = "Mariq", LastName = "Litova", HireDate = DateTime.Parse("2004-02-12") } }; context.Instructors.AddRange(instructors); context.SaveChanges(); var departments = new Department[] { new Department { Name = "English", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Trifonov").ID }, new Department { Name = "Mathematics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Raikov").ID }, new Department { Name = "Engineering", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Vachkov").ID }, new Department { Name = "Economics", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Atanasov").ID }, }; context.Departments.AddRange(departments); 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 }, }; context.Courses.AddRange(courses); context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Atanasov").ID, Location = "Smith 17" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Litova").ID, Location = "Gowan 27" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Raikov").ID, Location = "Thompson 304" }, }; context.OfficeAssignments.AddRange(officeAssignments); context.SaveChanges(); var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Atanasov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Vachkov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Litova").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, InstructorID = instructors.Single(i => i.LastName == "Litova").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, InstructorID = instructors.Single(i => i.LastName == "Raikov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, InstructorID = instructors.Single(i => i.LastName == "Vachkov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Composition").CourseID, InstructorID = instructors.Single(i => i.LastName == "Trifonov").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Literature").CourseID, InstructorID = instructors.Single(i => i.LastName == "Trifonov").ID }, }; context.CourseAssignments.AddRange(courseInstructors); 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}, new Enrollment { StudentID = students.Single(s => s.LastName == "Anderson").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anderson").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Anderson").ID, CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Petrov").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Petrov").ID, CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Petrov").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.D }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kancheva").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kancheva").ID, CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kanchev").ID, CourseID = courses.Single(c => c.Title == "Chemistry").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Todorov").ID, CourseID = courses.Single(c => c.Title == "Composition").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Morison").ID, CourseID = courses.Single(c => c.Title == "Literature").CourseID, Grade = Grade.A } }; context.Enrollments.AddRange(enrollments); context.SaveChanges(); 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(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstName = "Мила", LastName = "Милева", EnrollmentDate = DateTime.Parse("2010-09-01") }, new Student { FirstName = "Мария", LastName = "Петрова", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Пенка", LastName = "Димова", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstName = "Димитър", LastName = "Паскалев", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Жан", LastName = "Валжан", EnrollmentDate = DateTime.Parse("2012-09-01") }, new Student { FirstName = "Ния", LastName = "Желязкова", EnrollmentDate = DateTime.Parse("2011-09-01") }, new Student { FirstName = "Лаура", LastName = "Ботева", EnrollmentDate = DateTime.Parse("2013-09-01") }, new Student { FirstName = "Нино", LastName = "Пиронков", EnrollmentDate = DateTime.Parse("2025-09-01") } }; foreach (Student s in students) { context.Students.Add(s); } context.SaveChanges(); var instructors = new Instructor[] { new Instructor { FirstName = "Александър", LastName = "Добрев", HireDate = DateTime.Parse("1995-03-11") }, new Instructor { FirstName = "Симеон", LastName = "Иванов", HireDate = DateTime.Parse("2002-07-06") }, new Instructor { FirstName = "Крум", LastName = "Славов", HireDate = DateTime.Parse("1998-07-01") }, new Instructor { FirstName = "Ния", LastName = "Златанова", HireDate = DateTime.Parse("2001-01-15") }, new Instructor { FirstName = "Петя", LastName = "Вълканова", HireDate = DateTime.Parse("2004-02-12") } }; foreach (Instructor i in instructors) { context.Instructors.Add(i); } context.SaveChanges(); var departments = new Department[] { new Department { Name = "Макро икономика", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Славов").ID }, new Department { Name = "Микро икономика", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Иванов").ID }, new Department { Name = "Информатика", Budget = 350000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Добрев").ID }, new Department { Name = "Екология", Budget = 100000, StartDate = DateTime.Parse("2007-09-01"), InstructorID = instructors.Single(i => i.LastName == "Златанова").ID } }; foreach (Department d in departments) { context.Departments.Add(d); } context.SaveChanges(); var courses = new Course[] { new Course { CourseID = 1050, Title = "Фондови пазари", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Макро икономика").DepartmentID }, new Course { CourseID = 4022, Title = "Производителност на труда", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Микро икономика").DepartmentID }, new Course { CourseID = 4041, Title = "Програмиране", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Информатика").DepartmentID }, new Course { CourseID = 1045, Title = "Връзки с обществеността", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Микро икономика").DepartmentID }, new Course { CourseID = 3141, Title = "Работа в екип", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Информатика").DepartmentID }, new Course { CourseID = 2021, Title = "Опазване на околната среда", Credits = 3, DepartmentID = departments.Single(s => s.Name == "Екология").DepartmentID }, new Course { CourseID = 2042, Title = "Емоционална интелегентност", Credits = 4, DepartmentID = departments.Single(s => s.Name == "Информатика").DepartmentID }, }; foreach (Course c in courses) { context.Courses.Add(c); } context.SaveChanges(); var officeAssignments = new OfficeAssignment[] { new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Златанова").ID, Location = "Стара Загора" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Иванов").ID, Location = "Нова Згора" }, new OfficeAssignment { InstructorID = instructors.Single(i => i.LastName == "Добрев").ID, Location = "София" }, }; foreach (OfficeAssignment o in officeAssignments) { context.OfficeAssignments.Add(o); } context.SaveChanges(); var courseInstructors = new CourseAssignment[] { new CourseAssignment { CourseID = courses.Single(c => c.Title == "Фондови пазари").CourseID, InstructorID = instructors.Single(i => i.LastName == "Златанова").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Производителност на труда").CourseID, InstructorID = instructors.Single(i => i.LastName == "Иванов").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Програмиране").CourseID, InstructorID = instructors.Single(i => i.LastName == "Добрев").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Опазване на околната среда").CourseID, InstructorID = instructors.Single(i => i.LastName == "Вълканова").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Връзки с обществеността").CourseID, InstructorID = instructors.Single(i => i.LastName == "Славов").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Работа в екип").CourseID, InstructorID = instructors.Single(i => i.LastName == "Вълканова").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Емоционална интелегентност").CourseID, InstructorID = instructors.Single(i => i.LastName == "Славов").ID } }; foreach (CourseAssignment ci in courseInstructors) { context.CourseAssignments.Add(ci); } context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { StudentID = students.Single(s => s.LastName == "Димова").ID, CourseID = courses.Single(c => c.Title == "Фондови пазари").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Милева").ID, CourseID = courses.Single(c => c.Title == "Производителност на труда").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Валжан").ID, CourseID = courses.Single(c => c.Title == "Работа в екип").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Петрова").ID, CourseID = courses.Single(c => c.Title == "Програмиране").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Паскалев").ID, CourseID = courses.Single(c => c.Title == "Опазване на околната среда").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Пиронков").ID, CourseID = courses.Single(c => c.Title == "Връзки с обществеността").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Петрова").ID, CourseID = courses.Single(c => c.Title == "Фондови пазари").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Ботева").ID, CourseID = courses.Single(c => c.Title == "Фондови пазари").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Димова").ID, CourseID = courses.Single(c => c.Title == "Програмиране").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Петрова").ID, CourseID = courses.Single(c => c.Title == "Връзки с обществеността").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Димова").ID, CourseID = courses.Single(c => c.Title == "Работа в екип").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(); // Look for any students. if (context.Students.Any()) { return; // DB has been seeded } var students = new Student[] { new Student { FirstMidName = "Mark Matteus", LastName = "Murru", EnrollmentDate = DateTime.Parse("2019-08.20") }, new Student { FirstMidName = "Madli", LastName = "Kaevats", EnrollmentDate = DateTime.Parse("2019-08.20") }, new Student { FirstMidName = "Hugo", LastName = "Valk", EnrollmentDate = DateTime.Parse("2019-08.20") }, new Student { FirstMidName = "Johann", LastName = "Kuldmäe", EnrollmentDate = DateTime.Parse("2017-08.20") }, new Student { FirstMidName = "Elise", LastName = "Lomp", EnrollmentDate = DateTime.Parse("2019-08.20") }, new Student { FirstMidName = "Toru", LastName = "Jüri", EnrollmentDate = DateTime.Parse("2012-04.12") }, new Student { FirstMidName = "Sammal", LastName = "Habe", EnrollmentDate = DateTime.Parse("2013-03.14") }, new Student { FirstMidName = "Nipi", LastName = "Tiri", EnrollmentDate = DateTime.Parse("2010-02.18") } }; 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 = "Information Technology", 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 = 1702, Title = "Web Applications", Credits = 12, DepartmentID = departments.Single(s => s.Name == "Information Technology").DepartmentID }, new Course { CourseID = 0150, Title = "Economics", Credits = 6, DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 1615, Title = "Data Processing", Credits = 6, DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID }, new Course { CourseID = 1708, Title = "IT Operations", Credits = 6, DepartmentID = departments.Single(s => s.Name == "Information Technology").DepartmentID }, new Course { CourseID = 0153, Title = "Accounting", Credits = 6, DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID }, new Course { CourseID = 1618, Title = "Calculus", Credits = 6, DepartmentID = departments.Single(s => s.Name == "Mathematics").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 == "Web Applications").CourseID, InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Web Applications").CourseID, InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Calculus").CourseID, InstructorID = instructors.Single(i => i.LastName == "Zheng").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Economics").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 == "IT Operations").CourseID, InstructorID = instructors.Single(i => i.LastName == "Harui").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Data Processing").CourseID, InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID }, new CourseAssignment { CourseID = courses.Single(c => c.Title == "Economics").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 == "Valk").ID, CourseID = courses.Single(c => c.Title == "Economics").CourseID, Grade = Grade.A }, new Enrollment { StudentID = students.Single(s => s.LastName == "Lomp").ID, CourseID = courses.Single(c => c.Title == "Web Applications").CourseID, Grade = Grade.C }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kuldmäe").ID, CourseID = courses.Single(c => c.Title == "Web Applications").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kaevats").ID, CourseID = courses.Single(c => c.Title == "Calculus").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Kaevats").ID, CourseID = courses.Single(c => c.Title == "Data Processing").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Murru").ID, CourseID = courses.Single(c => c.Title == "IT Operations").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Tiri").ID, CourseID = courses.Single(c => c.Title == "IT Operations").CourseID }, new Enrollment { StudentID = students.Single(s => s.LastName == "Habe").ID, CourseID = courses.Single(c => c.Title == "Economics").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Habe").ID, CourseID = courses.Single(c => c.Title == "Data Processing").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Valk").ID, CourseID = courses.Single(c => c.Title == "Web Applications").CourseID, Grade = Grade.B }, new Enrollment { StudentID = students.Single(s => s.LastName == "Murru").ID, CourseID = courses.Single(c => c.Title == "Web Applications").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(); }