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();
}
