public static void Initialize(SchoolContext context)
{
context.Database.EnsureCreated();
if (context.students.Any())
{
return;
}
var students = new Student[]
{
new Student {
firstName = "Carson", lastName = "Alexander", dateEnrollment = DateTime.Parse("2005-09-01")
},
new Student {
firstName = "Meredith", lastName = "Alonso", dateEnrollment = DateTime.Parse("2002-09-01")
},
new Student {
firstName = "Arturo", lastName = "Anand", dateEnrollment = DateTime.Parse("2003-09-01")
},
new Student {
firstName = "Gytis", lastName = "Barzdukas", dateEnrollment = DateTime.Parse("2002-09-01")
},
new Student {
firstName = "Yan", lastName = "Li", dateEnrollment = DateTime.Parse("2002-09-01")
},
new Student {
firstName = "Peggy", lastName = "Justice", dateEnrollment = DateTime.Parse("2001-09-01")
},
new Student {
firstName = "Laura", lastName = "Norman", dateEnrollment = DateTime.Parse("2003-09-01")
},
new Student {
firstName = "Nino", lastName = "Olivetto", dateEnrollment = 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 {
departName = "English", budget = 350000,
departStartDate = DateTime.Parse("2007-09-01"),
instructorId = instructors.Single(i => i.lastName == "Abercrombie").id
},
new Department {
departName = "Mathematics", budget = 100000,
departStartDate = DateTime.Parse("2007-09-01"),
instructorId = instructors.Single(i => i.lastName == "Fakhouri").id
},
new Department {
departName = "Engineering", budget = 350000,
departStartDate = DateTime.Parse("2007-09-01"),
instructorId = instructors.Single(i => i.lastName == "Harui").id
},
new Department {
departName = "Economics", budget = 100000,
departStartDate = 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, courseTitle = "Chemistry", credit = 3,
departmentId = departments.Single(s => s.departName == "Engineering").departmentId
},
new Course {
courseId = 4022, courseTitle = "Microeconomics", credit = 3,
departmentId = departments.Single(s => s.departName == "Economics").departmentId
},
new Course {
courseId = 4041, courseTitle = "Macroeconomics", credit = 3,
departmentId = departments.Single(s => s.departName == "Economics").departmentId
},
new Course {
courseId = 1045, courseTitle = "Calculus", credit = 4,
departmentId = departments.Single(s => s.departName == "Mathematics").departmentId
},
new Course {
courseId = 3141, courseTitle = "Trigonometry", credit = 4,
departmentId = departments.Single(s => s.departName == "Mathematics").departmentId
},
new Course {
courseId = 2021, courseTitle = "Composition", credit = 3,
departmentId = departments.Single(s => s.departName == "English").departmentId
},
new Course {
courseId = 2042, courseTitle = "Literature", credit = 4,
departmentId = departments.Single(s => s.departName == "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.courseTitle == "Chemistry").courseId,
instructorId = instructors.Single(i => i.lastName == "Kapoor").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId,
instructorId = instructors.Single(i => i.lastName == "Harui").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId,
instructorId = instructors.Single(i => i.lastName == "Zheng").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Macroeconomics").courseId,
instructorId = instructors.Single(i => i.lastName == "Zheng").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Calculus").courseId,
instructorId = instructors.Single(i => i.lastName == "Fakhouri").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Trigonometry").courseId,
instructorId = instructors.Single(i => i.lastName == "Harui").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "Composition").courseId,
instructorId = instructors.Single(i => i.lastName == "Abercrombie").id
},
new CourseAssignment {
courseId = courses.Single(c => c.courseTitle == "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.courseTitle == "Chemistry").courseId,
grade = Enrollment.Grade.A
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Alexander").id,
courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId,
grade = Enrollment.Grade.C
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Alexander").id,
courseId = courses.Single(c => c.courseTitle == "Macroeconomics").courseId,
grade = Enrollment.Grade.B
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Alonso").id,
courseId = courses.Single(c => c.courseTitle == "Calculus").courseId,
grade = Enrollment.Grade.B
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Alonso").id,
courseId = courses.Single(c => c.courseTitle == "Trigonometry").courseId,
grade = Enrollment.Grade.B
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Alonso").id,
courseId = courses.Single(c => c.courseTitle == "Composition").courseId,
grade = Enrollment.Grade.B
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Anand").id,
courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId,
grade = Enrollment.Grade.D
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Anand").id,
courseId = courses.Single(c => c.courseTitle == "Microeconomics").courseId,
grade = Enrollment.Grade.D
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Barzdukas").id,
courseId = courses.Single(c => c.courseTitle == "Chemistry").courseId,
grade = Enrollment.Grade.B
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Li").id,
courseId = courses.Single(c => c.courseTitle == "Composition").courseId,
grade = Enrollment.Grade.F
},
new Enrollment {
studentId = students.Single(s => s.lastName == "Justice").id,
courseId = courses.Single(c => c.courseTitle == "Literature").courseId,
grade = Enrollment.Grade.B
}
};
foreach (Enrollment e in enrollments)
{
var enrollmentDb = context.enrollments.Where(
s =>
s.student.id == e.studentId &&
s.course.courseId == e.courseId
).SingleOrDefault();
if (enrollmentDb == null)
{
context.enrollments.Add(e);
}
}
context.SaveChanges();
} //End of class
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("2019-09-01")
},
new Student {
FirstMidName = "Meredith", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Arturo", LastName = "Anand", EnrollmentDate = DateTime.Parse("2018-09-01")
},
new Student {
FirstMidName = "Gytis", LastName = "Barzdukas", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Yan", LastName = "Li", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Peggy", LastName = "Justice", EnrollmentDate = DateTime.Parse("2016-09-01")
},
new Student {
FirstMidName = "Laura", LastName = "Norman", EnrollmentDate = DateTime.Parse("2018-09-01")
},
new Student {
FirstMidName = "Nino", LastName = "Olivetto", EnrollmentDate = DateTime.Parse("2019-09-01")
}
};
context.Students.AddRange(students);
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
}
};
context.Courses.AddRange(courses);
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
},
};
context.Enrollments.AddRange(enrollments);
context.SaveChanges();
}
