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 = "Ivan", LastName = "Alexander", EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
FirstMidName = "Mirko", LastName = "Alonso", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Asen", LastName = "Anand", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstMidName = "Kalina", LastName = "Baronova", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Yana", LastName = "Lilova", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Pitra", LastName = "Mandjarova", EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
FirstMidName = "Lila", LastName = "Norbekova", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstMidName = "Nilana", LastName = "Oranjeva", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.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.Courses.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.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[]
{
//tinfo200:[2021-03-11-logan23b-dykstra1] - student test data
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 courses = new Course[]
{
//tinfo200:[2021-03-11-logan23b-dykstra1] - courses test data
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);
}
//tinfo200:[2021-03-11-logan23b-dykstra1] - database object saving these changes
context.SaveChanges();
var enrollments = new Enrollment[]
{
//tinfo200:[2021-03-11-logan23b-dykstra1] - enrollment test data
//tinfo200:[2021-03-11-logan23b-dykstra1] - grade can be null (don't need one)
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)
{
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", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.4f, EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
FirstName = "Meredith", LastName = "Alonso", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 2.9f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Arturo", LastName = "Anand", EmailAddress = "*****@*****.**", YearRank = "Sophomore", AverageGrade = 3.9f, EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.5f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Yan", LastName = "Li", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 2.3f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Peggy", LastName = "Justice", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.2f, EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
FirstName = "Laura", LastName = "Norman", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.1f, EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Nino", LastName = "Olivetto", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 4.0f, EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
CourseID = 1050, Title = "Chemistry", Credits = 3, RoomNum = "BHS 409"
},
new Course {
CourseID = 4022, Title = "Microeconomics", Credits = 3, RoomNum = "CP 503"
},
new Course {
CourseID = 4041, Title = "Macroeconomics", Credits = 3, RoomNum = "WG 689"
},
new Course {
CourseID = 1045, Title = "Calculus", Credits = 4, RoomNum = "GWP 110"
},
new Course {
CourseID = 3141, Title = "Trigonometry", Credits = 4, RoomNum = "MAT 941"
},
new Course {
CourseID = 2021, Title = "Composition", Credits = 3, RoomNum = "WCG 001"
},
new Course {
CourseID = 2042, Title = "Literature", Credits = 4, RoomNum = "BB 276"
}
};
foreach (Course c in courses)
{
context.Courses.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.Enrollments.Add(e);
}
context.SaveChanges();
}
public static void Initialize(SchoolContext context)
{
if (context.Students.Any())
{
return; // DB has been seeded
}
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 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 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)
{
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var alexander = new Student
{
FirstMidName = "Carson",
LastName = "Alexander",
EnrollmentDate = DateTime.Parse("2016-09-01")
};
var alonso = new Student
{
FirstMidName = "Meredith",
LastName = "Alonso",
EnrollmentDate = DateTime.Parse("2018-09-01")
};
var anand = new Student
{
FirstMidName = "Arturo",
LastName = "Anand",
EnrollmentDate = DateTime.Parse("2019-09-01")
};
var barzdukas = new Student
{
FirstMidName = "Gytis",
LastName = "Barzdukas",
EnrollmentDate = DateTime.Parse("2018-09-01")
};
var li = new Student
{
FirstMidName = "Yan",
LastName = "Li",
EnrollmentDate = DateTime.Parse("2018-09-01")
};
var justice = new Student
{
FirstMidName = "Peggy",
LastName = "Justice",
EnrollmentDate = DateTime.Parse("2017-09-01")
};
var norman = new Student
{
FirstMidName = "Laura",
LastName = "Norman",
EnrollmentDate = DateTime.Parse("2019-09-01")
};
var olivetto = new Student
{
FirstMidName = "Nino",
LastName = "Olivetto",
EnrollmentDate = DateTime.Parse("2011-09-01")
};
var abercrombie = new Instructor
{
FirstMidName = "Kim",
LastName = "Abercrombie",
HireDate = DateTime.Parse("1995-03-11")
};
var fakhouri = new Instructor
{
FirstMidName = "Fadi",
LastName = "Fakhouri",
HireDate = DateTime.Parse("2002-07-06")
};
var harui = new Instructor
{
FirstMidName = "Roger",
LastName = "Harui",
HireDate = DateTime.Parse("1998-07-01")
};
var kapoor = new Instructor
{
FirstMidName = "Candace",
LastName = "Kapoor",
HireDate = DateTime.Parse("2001-01-15")
};
var zheng = new Instructor
{
FirstMidName = "Roger",
LastName = "Zheng",
HireDate = DateTime.Parse("2004-02-12")
};
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
Instructor = fakhouri,
Location = "Smith 17"
},
new OfficeAssignment {
Instructor = harui,
Location = "Gowan 27"
},
new OfficeAssignment {
Instructor = kapoor,
Location = "Thompson 304"
},
};
context.AddRange(officeAssignments);
var english = new Department
{
Name = "English",
Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = abercrombie,
ConcurrencyToken = Guid.NewGuid()
};
var mathematics = new Department
{
Name = "Mathematics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = fakhouri,
ConcurrencyToken = Guid.NewGuid()
};
var engineering = new Department
{
Name = "Engineering",
Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = harui,
ConcurrencyToken = Guid.NewGuid()
};
var economics = new Department
{
Name = "Economics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = kapoor,
ConcurrencyToken = Guid.NewGuid()
};
var chemistry = new Course
{
CourseID = 1050,
Title = "Chemistry",
Credits = 3,
Department = engineering,
Instructors = new List <Instructor> {
kapoor, harui
}
};
var microeconomics = new Course
{
CourseID = 4022,
Title = "Microeconomics",
Credits = 3,
Department = economics,
Instructors = new List <Instructor> {
zheng
}
};
var macroeconmics = new Course
{
CourseID = 4041,
Title = "Macroeconomics",
Credits = 3,
Department = economics,
Instructors = new List <Instructor> {
zheng
}
};
var calculus = new Course
{
CourseID = 1045,
Title = "Calculus",
Credits = 4,
Department = mathematics,
Instructors = new List <Instructor> {
fakhouri
}
};
var trigonometry = new Course
{
CourseID = 3141,
Title = "Trigonometry",
Credits = 4,
Department = mathematics,
Instructors = new List <Instructor> {
harui
}
};
var composition = new Course
{
CourseID = 2021,
Title = "Composition",
Credits = 3,
Department = english,
Instructors = new List <Instructor> {
abercrombie
}
};
var literature = new Course
{
CourseID = 2042,
Title = "Literature",
Credits = 4,
Department = english,
Instructors = new List <Instructor> {
abercrombie
}
};
var enrollments = new Enrollment[]
{
new Enrollment {
Student = alexander,
Course = chemistry,
Grade = Grade.A
},
new Enrollment {
Student = alexander,
Course = microeconomics,
Grade = Grade.C
},
new Enrollment {
Student = alexander,
Course = macroeconmics,
Grade = Grade.B
},
new Enrollment {
Student = alonso,
Course = calculus,
Grade = Grade.B
},
new Enrollment {
Student = alonso,
Course = trigonometry,
Grade = Grade.B
},
new Enrollment {
Student = alonso,
Course = composition,
Grade = Grade.B
},
new Enrollment {
Student = anand,
Course = chemistry,
},
new Enrollment {
Student = anand,
Course = microeconomics,
Grade = Grade.B
},
new Enrollment {
Student = barzdukas,
Course = chemistry,
Grade = Grade.B
},
new Enrollment {
Student = li,
Course = composition,
Grade = Grade.B
},
new Enrollment {
Student = justice,
Course = literature,
Grade = Grade.B
}
};
context.AddRange(enrollments);
context.SaveChanges();
}
public static void Initialize(SchoolContext context)
{
context.Database.EnsureCreated();
// Look for any courses.
if (context.PCourses.Any())
{
return; // DB has been seeded
}
//** ------------students------------ **//
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();
//** ------------propedeuse------------ **//
var pcourses = new PropedeuseCourse[]
{
new PropedeuseCourse {
ID = 1,
code = "IPMEDT1",
title = "Project Mediatechnologie intro",
credits = 6
},
new PropedeuseCourse {
ID = 2,
code = "IMTHB",
title = "Mediatechnologie HTML Basics",
credits = 3
},
new PropedeuseCourse {
ID = 3,
code = "IOPR1",
title = "Objectgeoriënteerd programmeren 1",
credits = 4
},
new PropedeuseCourse {
ID = 4,
code = "IPBIT1",
title = "Project Business IT intro",
credits = 5
},
new PropedeuseCourse {
ID = 5,
code = "ISMI",
title = "Inleiding Business IT",
credits = 3
},
new PropedeuseCourse {
ID = 6,
code = "IBPM",
title = "Inleiding informatiemanagement / BPM",
credits = 3
},
new PropedeuseCourse {
ID = 7,
code = "IOPR2",
title = "Objectgeoriënteerd programmeren 2",
credits = 4
},
new PropedeuseCourse {
ID = 8,
code = "IPSEN",
title = "MProject Software Engineering intro",
credits = 5
},
new PropedeuseCourse {
ID = 9,
code = "IMUML",
title = "Modelleren in Unified Modelling Language",
credits = 3
},
new PropedeuseCourse {
ID = 10,
code = "IRDB",
title = "Relationele Databases",
credits = 3
},
new PropedeuseCourse {
ID = 11,
code = "ITIM",
title = "Toekomst, Innovatie & Media",
credits = 3
},
new PropedeuseCourse {
ID = 12,
code = "ICOMNL",
title = "Inleiding communicatievaardigheden",
credits = 3
},
new PropedeuseCourse {
ID = 13,
code = "IPFIT1",
title = "Project forensische ICT intro",
credits = 5
},
new PropedeuseCourse {
ID = 14,
code = "IFIT",
title = "Inleiding Forensische ICT",
credits = 3
},
new PropedeuseCourse {
ID = 15,
code = "IWEB",
title = "Webtechnologie",
credits = 3
},
new PropedeuseCourse {
ID = 16,
code = "INST",
title = "IT netwerkstructuren",
credits = 3
},
new PropedeuseCourse {
ID = 17,
code = "ISL01",
title = "Studieloopbaan begeleiding",
credits = 1
}
};
foreach (PropedeuseCourse c in pcourses)
{
context.PCourses.Add(c);
}
context.SaveChanges();
var keuzeVak = new KeuzevVak[]
{
new KeuzevVak {
ID = 1,
code = "IPMEDT1",
title = "Project Mediatechnologie intro",
credits = 6
},
new KeuzevVak {
ID = 2,
code = "IMTHB",
title = "Mediatechnologie HTML Basics",
credits = 3
},
new KeuzevVak {
ID = 3,
code = "IOPR1",
title = "Objectgeoriënteerd programmeren 1",
credits = 4
},
new KeuzevVak {
ID = 4,
code = "IPBIT1",
title = "Project Business IT intro",
credits = 5
},
new KeuzevVak {
ID = 5,
code = "ISMI",
title = "Inleiding Business IT",
credits = 3
},
new KeuzevVak {
ID = 6,
code = "IBPM",
title = "Inleiding informatiemanagement / BPM",
credits = 3
},
new KeuzevVak {
ID = 7,
code = "IOPR2",
title = "Objectgeoriënteerd programmeren 2",
credits = 4
},
new KeuzevVak {
ID = 8,
code = "IPSEN",
title = "MProject Software Engineering intro",
credits = 5
},
new KeuzevVak {
ID = 9,
code = "IMUML",
title = "Modelleren in Unified Modelling Language",
credits = 3
},
new KeuzevVak {
ID = 10,
code = "IRDB",
title = "Relationele Databases",
credits = 3
},
new KeuzevVak {
ID = 11,
code = "ITIM",
title = "Toekomst, Innovatie & Media",
credits = 3
},
new KeuzevVak {
ID = 12,
code = "ICOMNL",
title = "Inleiding communicatievaardigheden",
credits = 3
},
new KeuzevVak {
ID = 13,
code = "IPFIT1",
title = "Project forensische ICT intro",
credits = 5
},
new KeuzevVak {
ID = 14,
code = "IFIT",
title = "Inleiding Forensische ICT",
credits = 3
},
new KeuzevVak {
ID = 15,
code = "IWEB",
title = "Webtechnologie",
credits = 3
},
new KeuzevVak {
ID = 16,
code = "INST",
title = "IT netwerkstructuren",
credits = 3
},
new KeuzevVak {
ID = 17,
code = "ISL01",
title = "Studieloopbaan begeleiding",
credits = 1
}
};
foreach (PropedeuseCourse c in pcourses)
{
context.PCourses.Add(c);
}
context.SaveChanges();
//** ------------mtCourses------------ **//
var mtCourses = new MTCourse[]
{
new MTCourse {
ID = 1,
code = "IRDBMS",
title = "Relationele Databasemanagementsystemen",
credits = 3
},
new MTCourse {
ID = 2,
code = "IPMEDT2",
title = "Project Mediatechnologie 2",
credits = 6
},
new MTCourse {
ID = 3,
code = "IMTD1",
title = "Mediatechnologie Design 1",
credits = 3
},
new MTCourse {
ID = 4,
code = "IQUA",
title = "Kwaliteit in de IT",
credits = 3
},
new MTCourse {
ID = 5,
code = "IPMEDT3",
title = "Project Mediatechnologie 3",
credits = 6
},
new MTCourse {
ID = 6,
code = "ITORG",
title = "Inleiding Organisatiekunde",
credits = 3
},
new MTCourse {
ID = 7,
code = "IPMEDT4",
title = "Project Mediatechnologie 4",
credits = 6
},
new MTCourse {
ID = 8,
code = "IMTPMD",
title = "Programming for Mobile Devices",
credits = 3
},
new MTCourse {
ID = 9,
code = "ISEC",
title = "IT Security",
credits = 3
},
new MTCourse {
ID = 10,
code = "IPMEDT5",
title = "Project Mediatechnologie 5",
credits = 6
},
new MTCourse {
ID = 11,
code = "IMTHE1",
title = "Mediatechnologie Hardware Engineering 1",
credits = 3
},
new MTCourse {
ID = 12,
code = "IFP2",
title = "Projectmanagement volgens Prince 2",
credits = 3
},
new MTCourse {
ID = 13,
code = "IETH",
title = "Ethiek",
credits = 3
},
new MTCourse {
ID = 14,
code = "IPMEDTH",
title = "Project Mediatechnologie hoofdfase",
credits = 9
},
new MTCourse {
ID = 15,
code = "IMTCM",
title = "Mediatechnologie Creative Marketing",
credits = 3
},
new MTCourse {
ID = 16,
code = "IMTMC",
title = "Mediatechnologie Marketing en Communicatie",
credits = 3
},
new MTCourse {
ID = 17,
code = "ICOMH",
title = "Communicatie hoofdfase",
credits = 3
},
new MTCourse {
ID = 18,
code = "ISLH1",
title = "Studieloopbaanbegeleiding 2",
credits = 3
},
new MTCourse {
ID = 19,
code = "ISLH2",
title = "Studieloopbaanbegeleiding 3",
credits = 1
},
new MTCourse {
ID = 20,
code = "ISLH3",
title = "Studieloopbaanbegeleiding 4",
credits = 1
},
new MTCourse {
ID = 21,
code = "IMTHMI",
title = "Human-Machine-interaction",
credits = 3
},
new MTCourse {
ID = 22,
code = "Minor",
title = "Minor",
credits = 30
},
new MTCourse {
ID = 23,
code = "IWLS",
title = "Stage",
credits = 30
},
new MTCourse {
ID = 24,
code = "IWLA",
title = "Afstuderen",
credits = 30
}
};
foreach (MTCourse c in mtCourses)
{
context.MtCourses.Add(c);
}
context.SaveChanges();
//** ------------enrollment------------ **//
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)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
//tinfo200:[2021-03-12-<meeras4>-dykstra2] - Purpose for test code is if there's no code found in database, the database will be created with loaded test data of arrays
var students = new Student[]
{
//tinfo200:[2021-03-12-<meeras4>-dykstra2] - Assigning data for students
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 courses = new Course[]
{
//tinfo200:[2021-03-12-<meeras4>-dykstra2] - Assigning data for the courses
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 enrollments = new Enrollment[]
{
//tinfo200:[2021-03-12-<meeras4>-dykstra2] - Assigning grades for the enrollment classes
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)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
// sample data for Student
var students = new Student[]
{
new Student {
FirstName = "Carson", LastName = "Alexander", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.4f, EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
FirstName = "Meredith", LastName = "Alonso", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 2.9f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Arturo", LastName = "Anand", EmailAddress = "*****@*****.**", YearRank = "Sophomore", AverageGrade = 3.9f, EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.5f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Yan", LastName = "Li", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 2.3f, EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Peggy", LastName = "Justice", EmailAddress = "*****@*****.**", YearRank = "Junior", AverageGrade = 3.2f, EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
FirstName = "Laura", LastName = "Norman", EmailAddress = "*****@*****.**", YearRank = "Freshmen", AverageGrade = 3.1f, EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Nino", LastName = "Olivetto", EmailAddress = "*****@*****.**", YearRank = "Senior", AverageGrade = 4.0f, EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
// sample data for Instructor
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")
},
new Instructor {
FirstName = "John", LastName = "David",
HireDate = DateTime.Parse("2004-03-10")
}
};
foreach (Instructor i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
// sample data for Department
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
},
new Department {
Name = "Information Technology", Budget = 200000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.LastName == "David").ID
}
};
foreach (Department d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
// sample data for Course
var courses = new Course[]
{
new Course {
CourseID = 1050, Title = "Chemistry", Credits = 3, RoomNum = "BHS 409",
DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID
},
new Course {
CourseID = 4022, Title = "Microeconomics", Credits = 3, RoomNum = "CP 503",
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Course {
CourseID = 4041, Title = "Macroeconomics", Credits = 3, RoomNum = "WG 689",
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Course {
CourseID = 1045, Title = "Calculus", Credits = 4, RoomNum = "GWP 110",
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Course {
CourseID = 3141, Title = "Trigonometry", Credits = 4, RoomNum = "MAT 941",
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Course {
CourseID = 2021, Title = "Composition", Credits = 3, RoomNum = "WCG 001",
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
new Course {
CourseID = 2042, Title = "Literature", Credits = 4, RoomNum = "BB 276",
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
new Course {
CourseID = 2078, Title = "ASP.NET MVC Web App", Credits = 4, RoomNum = "BB 276",
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
}
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
// sample data for Enrollment
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
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Olivetto").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.A
}
};
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();
// sample data for Office Assignment
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"
},
new OfficeAssignment {
InstructorID = instructors.Single(i => i.LastName == "David").ID,
Location = "MAT 304"
},
};
foreach (OfficeAssignment o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
// sample data for Course Assignment
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();
}
public static void Initialize(SchoolContext context)
{
//tinfo200:[2021-03-13-hn98-dykstra1] -EF creates an empty database. In this section, a method is added that's called after the database is created in order to populate it with test data.
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
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 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 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)
{
// context.Database.EnsureCreated();
//this looks for any students
if (context.Students.Any())
{
return;
}
var students = new Student[]
{
new Student {
FirstName = "Shuhratjan", LastName = "Nizamov", EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
FirstName = "Nurtileu", LastName = "Aliyas", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Moldir", LastName = "Kaliyas", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Nazym", LastName = "Soltumuratova", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Asanali", LastName = "Kereshov", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstName = "Muhamed", LastName = "Tolemis", EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
FirstName = "Saken", LastName = "Baymukhamed", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstName = "Asylzhan", LastName = "Erzhanov", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student student in students)
{
context.Students.Add(student);
}
context.SaveChanges();
var instructors = new Instructor[]
{
new Instructor {
FirstMidName = "Almas", LastName = "Byrleskenovich",
HireDate = DateTime.Parse("2018-03-11")
},
new Instructor {
FirstMidName = "Gulbanu", LastName = "Khasenova",
HireDate = DateTime.Parse("2002-07-06")
},
new Instructor {
FirstMidName = "Aizhan", LastName = "Doskozhanova",
HireDate = DateTime.Parse("1998-07-01")
},
new Instructor {
FirstMidName = "Ilyas", LastName = "Zhuanishev",
HireDate = DateTime.Parse("2001-01-15")
},
new Instructor {
FirstMidName = "Azamat", LastName = "Tolegenov",
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 == "Doskozhanova").ID
},
new Department {
Name = "Mathematics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID
},
new Department {
Name = "Engineering", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID
},
new Department {
Name = "Economics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.LastName == "Tolegenov").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 == "Byrleskenovich").ID,
Location = "Almaty 17"
},
new OfficeAssignment {
InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID,
Location = "Astana 27"
},
new OfficeAssignment {
InstructorID = instructors.Single(i => i.LastName == "Tolegenov").ID,
Location = "Shymkent 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 == "Tolegenov").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Byrleskenovich").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Calculus").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Zhuanishev").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Khasenova").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Doskozhanova").ID
},
new CourseAssignment {
CourseID = courses.Single(c => c.Title == "Literature").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Doskozhanova").ID
},
};
foreach (CourseAssignment ci in courseInstructors)
{
context.CourseAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentID = students.Single(s => s.LastName == "Nizamov").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Grade.A
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Aliyas").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.C
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Kaliyas").ID,
CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Soltumuratova").ID,
CourseID = courses.Single(c => c.Title == "Calculus").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Tolemis").ID,
CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Nizamov").ID,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Aliyas").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Kaliyas").ID,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Soltumuratova").ID,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Erzhanov").ID,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Grade.B
},
new Enrollment {
StudentID = students.Single(s => s.LastName == "Baymukhamed").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)
{ // tinfo200:[2021-03-12-kfrey02-dykstra2] added test database to the program so that the website has perceivable information inside the overarching database
// tinfo200:[2021-03-12-kfrey02-dykstra2] the code will also add the information to the students context and save the changes that were made to the context
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
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 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 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)
{
context.Database.EnsureCreated();
// look for student
if (context.Students.Any())
{
return; // DB has been seeded
}
// First time run
var students = new Student[]
{
new Student {
FirstMidName = "Sandeep Kumar",
LastName = "Dewangan",
EnrollmentDate = DateTime.Parse("2021-09-01")
},
new Student {
FirstMidName = "Khushbu",
LastName = "Dewangan",
EnrollmentDate = DateTime.Parse("2021-09-01")
},
new Student {
FirstMidName = "Tejaswini",
LastName = "Dewangan",
EnrollmentDate = DateTime.Parse("2021-09-01")
},
};
foreach (Student s in students)
{
context.Students.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.Courses.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.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.Players.Any())
{
return; // DB has been seeded
}
var players = new Player[]
{
new Player {
FirstMidName = "Carson", LastName = "Alexander",
ContractDate = DateTime.Parse("2016-09-01")
},
new Player {
FirstMidName = "Meredith", LastName = "Alonso",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Arturo", LastName = "Anand",
ContractDate = DateTime.Parse("2019-09-01")
},
new Player {
FirstMidName = "Gytis", LastName = "Barzdukas",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Yan", LastName = "Li",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Peggy", LastName = "Justice",
ContractDate = DateTime.Parse("2017-09-01")
},
new Player {
FirstMidName = "Laura", LastName = "Norman",
ContractDate = DateTime.Parse("2019-09-01")
},
new Player {
FirstMidName = "Nino", LastName = "Olivetto",
ContractDate = DateTime.Parse("2011-09-01")
}
};
context.Players.AddRange(players);
context.SaveChanges();
var coaches = new Coach[]
{
new Coach {
FirstMidName = "Kim", LastName = "Abercrombie",
HireDate = DateTime.Parse("1995-03-11")
},
new Coach {
FirstMidName = "Fadi", LastName = "Fakhouri",
HireDate = DateTime.Parse("2002-07-06")
},
new Coach {
FirstMidName = "Roger", LastName = "Harui",
HireDate = DateTime.Parse("1998-07-01")
},
new Coach {
FirstMidName = "Candace", LastName = "Kapoor",
HireDate = DateTime.Parse("2001-01-15")
},
new Coach {
FirstMidName = "Roger", LastName = "Zheng",
HireDate = DateTime.Parse("2004-02-12")
}
};
context.Coaches.AddRange(coaches);
context.SaveChanges();
var departments = new Department[]
{
new Department {
Name = "English", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
new Department {
Name = "Mathematics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID
},
new Department {
Name = "Engineering", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new Department {
Name = "Economics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID
}
};
context.Departments.AddRange(departments);
context.SaveChanges();
var teams = new Team[]
{
new Team {
TeamID = 1050, Title = "Chemistry", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID
},
new Team {
TeamID = 4022, Title = "Microeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Team {
TeamID = 4041, Title = "Macroeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Team {
TeamID = 1045, Title = "Calculus", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Team {
TeamID = 3141, Title = "Trigonometry", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Team {
TeamID = 2021, Title = "Composition", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
new Team {
TeamID = 2042, Title = "Literature", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
};
context.Teams.AddRange(teams);
context.SaveChanges();
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID,
Location = "Smith 17"
},
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Harui").ID,
Location = "Gowan 27"
},
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID,
Location = "Thompson 304"
},
};
context.OfficeAssignments.AddRange(officeAssignments);
context.SaveChanges();
var teamCoaches = new TeamAssignment[]
{
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
CoachID = coaches.Single(i => i.LastName == "Zheng").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Macroeconomics").TeamID,
CoachID = coaches.Single(i => i.LastName == "Zheng").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Calculus").TeamID,
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Trigonometry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Literature").TeamID,
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
};
context.TeamAssignments.AddRange(teamCoaches);
context.SaveChanges();
var contracts = new Contract[]
{
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
Grade = Grade.A
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
Grade = Grade.C
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Macroeconomics").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Calculus").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Trigonometry").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Anand").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Anand").ID,
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Barzdukas").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Li").ID,
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Justice").ID,
TeamID = teams.Single(c => c.Title == "Literature").TeamID,
Grade = Grade.B
}
};
foreach (Contract e in contracts)
{
var contractInDataBase = context.Contracts.Where(
s =>
s.Player.ID == e.PlayerID &&
s.Team.TeamID == e.TeamID).SingleOrDefault();
if (contractInDataBase == null)
{
context.Contracts.Add(e);
}
}
context.SaveChanges();
}
public static void Initialize(SchoolContext context)
{
// Look for any students
if (context.Students.Any())
{
Console.WriteLine("Found one");
// DB has data or has been seeded
return;
}
Console.WriteLine("None found");
// students
var studentPM = new Student {
FirstMidName = "Peter", LastName = "Mayaga", EnrollmentDate = DateTime.Parse("2015-05-03")
};
var studentJK = new Student {
FirstMidName = "John", LastName = "Kampulunguse", EnrollmentDate = DateTime.Parse("2018-12-30")
};
var studentWS = new Student {
FirstMidName = "Were", LastName = "Simon", EnrollmentDate = DateTime.Parse("2020-10-21")
};
var studentCJ = new Student {
FirstMidName = "Collins", LastName = "Jackson", EnrollmentDate = DateTime.Parse("2009-01-02")
};
var studentMS = new Student {
FirstMidName = "Matthew", LastName = "Sekitoleko", EnrollmentDate = DateTime.Parse("2021-3-23")
};
// instructors
var instructor1 = new Instructor {
FirstMidName = "John", LastName = "Ung", HireDate = DateTime.Parse("2001-04-14")
};
var instructor2 = new Instructor {
FirstMidName = "Kabenge", LastName = "Moses", HireDate = DateTime.Parse("2005-01-29")
};
var instructor3 = new Instructor {
FirstMidName = "Ssenoga", LastName = "Abram", HireDate = DateTime.Parse("2001-11-02")
};
var instructor4 = new Instructor {
FirstMidName = "Wandegeya", LastName = "Kulekana", HireDate = DateTime.Parse("2015-10-30")
};
// OfficeAssignments
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
Instructor = instructor1, Location = "LLT-1A"
},
new OfficeAssignment {
Instructor = instructor3, Location = "LLT-2B"
},
new OfficeAssignment {
Instructor = instructor4, Location = "Big lab A"
}
};
context.AddRange(officeAssignments);
// departments
var english = new Department
{
Name = "English",
Budget = 300000,
StartDate = DateTime.Parse("1990-02-15"),
Administrator = instructor1
};
var mathematics = new Department
{
Name = "Mathematics",
Budget = 250000,
StartDate = DateTime.Parse("1960-10-25"),
Administrator = instructor2
};
var cs = new Department
{
Name = "Computer Science",
Budget = 500000,
StartDate = DateTime.Parse("1990-09-22"),
Administrator = instructor3
};
// courses
var chemistry = new Course
{
CourseID = 1050,
Title = "Chemistry",
Credits = 3,
Department = mathematics,
Instructors = new List <Instructor> {
instructor1, instructor2
}
};
var SE = new Course
{
CourseID = 5060,
Title = "Software Engineering",
Credits = 4,
Department = cs,
Instructors = new List <Instructor> {
instructor2, instructor3
}
};
var discreteMaths = new Course
{
CourseID = 5090,
Title = "Discrete Mathematics",
Credits = 5,
Department = cs,
Instructors = new List <Instructor> {
instructor2, instructor3, instructor4
}
};
// Enrollments
var enrollments = new Enrollment[]
{
new Enrollment
{
Student = studentCJ,
Course = chemistry,
Grade = Grade.D
},
new Enrollment
{
Student = studentJK,
Course = discreteMaths
},
new Enrollment
{
Student = studentPM,
Course = SE,
Grade = Grade.A
},
new Enrollment
{
Student = studentJK,
Course = SE,
Grade = Grade.B
},
new Enrollment
{
Student = studentMS,
Course = chemistry
}
// studentWS not used
};
context.AddRange(enrollments);
// Save changes
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 = "Brown", LastName = "Ryan", EnrollmentDate = DateTime.Parse("2005-09-01")
},
new Student {
FirstMidName = "Wright", LastName = "Candace", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Wright", LastName = "Caitlin", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstMidName = "Wright", LastName = "Taylor", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Wright", LastName = "Madison", EnrollmentDate = DateTime.Parse("2002-09-01")
},
new Student {
FirstMidName = "Perez", LastName = "Serina", EnrollmentDate = DateTime.Parse("2001-09-01")
},
new Student {
FirstMidName = "Perez", LastName = "Natalie", EnrollmentDate = DateTime.Parse("2003-09-01")
},
new Student {
FirstMidName = "Brown", LastName = "Layla", EnrollmentDate = DateTime.Parse("2005-09-01")
}
};
foreach (Student s in students)
{
context.Students.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.Courses.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.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
}
// The code checks if there are any students in the database, and if not, it assumes the database is new
// and needs to be seeded with test data.It loads test data into arrays rather than List<T> collections
// to optimize performance.
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 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 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)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var students = new Student[]
{
new Student {
FirstMidName = "Joe", LastName = "Banana",
EnrollmentDate = DateTime.Parse("2010-01-01")
},
new Student {
FirstMidName = "Sofia", LastName = "Berlin",
EnrollmentDate = DateTime.Parse("2012-01-01")
},
new Student {
FirstMidName = "Silistra", LastName = "Busters",
EnrollmentDate = DateTime.Parse("2013-01-01")
},
new Student {
FirstMidName = "Ivan", LastName = "B.",
EnrollmentDate = DateTime.Parse("2012-01-01")
},
new Student {
FirstMidName = "Mina", LastName = "Batman",
EnrollmentDate = DateTime.Parse("2011-01-01")
},
new Student {
FirstMidName = "Pesho", LastName = "Zorro",
EnrollmentDate = DateTime.Parse("2013-01-01")
},
new Student {
FirstMidName = "Hristomir", LastName = "Hristov",
EnrollmentDate = DateTime.Parse("2005-01-01")
}
};
foreach (Student s in students)
{
context.Students.Add(s);
}
context.SaveChanges();
var instructors = new Instructor[]
{
new Instructor {
FirstMidName = "Krachun", LastName = "Malchov",
HireDate = DateTime.Parse("1995-03-11")
},
new Instructor {
FirstMidName = "Safadi", LastName = "Yordanov",
HireDate = DateTime.Parse("2002-07-06")
},
new Instructor {
FirstMidName = "Hristo", LastName = "Stoichkov",
HireDate = DateTime.Parse("1998-07-01")
},
new Instructor {
FirstMidName = "Yordan", LastName = "Lechkov",
HireDate = DateTime.Parse("2001-01-15")
},
new Instructor {
FirstMidName = "Hristo", LastName = "Zhabov",
HireDate = DateTime.Parse("2004-02-12")
}
};
foreach (Instructor i in instructors)
{
context.Instructors.Add(i);
}
context.SaveChanges();
var departments = new Department[]
{
new Department {
Name = "Advanced Design", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorId = instructors.Single(i => i.LastName == "Malchov").Id
},
new Department {
Name = "Design", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id
},
new Department {
Name = "Advanced Structures", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id
},
new Department {
Name = "Advanced Programming", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id
}
};
foreach (Department d in departments)
{
context.Departments.Add(d);
}
context.SaveChanges();
var courses = new Course[]
{
new Course {
CourseId = 1050, Title = "General Programming", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Advanced Structures").DepartmentId
},
new Course {
CourseId = 4022, Title = "Programming 101", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Advanced Programming").DepartmentId
},
new Course {
CourseId = 4041, Title = "Programming 201", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Advanced Programming").DepartmentId
},
new Course {
CourseId = 1045, Title = "Algorithms", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "Design").DepartmentId
},
new Course {
CourseId = 3141, Title = "Front End", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "Design").DepartmentId
},
new Course {
CourseId = 2021, Title = "Back End", Credits = 3,
DepartmentId = departments.Single(s => s.Name == "Advanced Design").DepartmentId
},
new Course {
CourseId = 2042, Title = "CSS", Credits = 4,
DepartmentId = departments.Single(s => s.Name == "Advanced Design").DepartmentId
},
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
context.SaveChanges();
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id,
Location = "Nuremberg"
},
new OfficeAssignment {
InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id,
Location = "Sofia"
},
new OfficeAssignment {
InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id,
Location = "Silistra"
},
};
foreach (OfficeAssignment o in officeAssignments)
{
context.OfficeAssignments.Add(o);
}
context.SaveChanges();
var courseInstructors = new CourseAssignment[]
{
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "General Programming").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Lechkov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "General Programming").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Programming 101").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Zhabov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Programming 201").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Zhabov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Algorithms").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Yordanov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Front End").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Stoichkov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "Back End").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Malchov").Id
},
new CourseAssignment {
CourseId = courses.Single(c => c.Title == "CSS").CourseId,
InstructorId = instructors.Single(i => i.LastName == "Malchov").Id
},
};
foreach (CourseAssignment ci in courseInstructors)
{
context.CourseAssignments.Add(ci);
}
context.SaveChanges();
var enrollments = new Enrollment[]
{
new Enrollment {
StudentId = students.Single(s => s.LastName == "Banana").Id,
CourseId = courses.Single(c => c.Title == "General Programming").CourseId,
Grade = Grade.A
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Banana").Id,
CourseId = courses.Single(c => c.Title == "Programming 101").CourseId,
Grade = Grade.C
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Banana").Id,
CourseId = courses.Single(c => c.Title == "Programming 201").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Berlin").Id,
CourseId = courses.Single(c => c.Title == "Algorithms").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Berlin").Id,
CourseId = courses.Single(c => c.Title == "Front End").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Berlin").Id,
CourseId = courses.Single(c => c.Title == "Back End").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Busters").Id,
CourseId = courses.Single(c => c.Title == "General Programming").CourseId
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Busters").Id,
CourseId = courses.Single(c => c.Title == "Programming 101").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "B.").Id,
CourseId = courses.Single(c => c.Title == "General Programming").CourseId,
Grade = Grade.B
},
new Enrollment {
StudentId = students.Single(s => s.LastName == "Batman").Id,
CourseId = courses.Single(c => c.Title == "CSS").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 = "Sagnik", LastName = "Chatterjee", EnrollmentDate = DateTime.Parse("2019-09-01")
},
new Student {
FirstMidName = "Proloy", LastName = "Bhaduri", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Debmalya", LastName = "Dutta", EnrollmentDate = DateTime.Parse("2018-09-01")
},
new Student {
FirstMidName = "Rupam", LastName = "Sen", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Darshan", LastName = "Sen", EnrollmentDate = DateTime.Parse("2017-09-01")
},
new Student {
FirstMidName = "Sandipan", LastName = "Bera", EnrollmentDate = DateTime.Parse("2016-09-01")
},
new Student {
FirstMidName = "Sayak", LastName = "Chakroborty", EnrollmentDate = DateTime.Parse("2018-09-01")
},
new Student {
FirstMidName = "Soumyajit", LastName = "Bera", EnrollmentDate = DateTime.Parse("2019-09-01")
}
};
context.Students.AddRange(students);
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")
}
};
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 == "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
}
};
context.Departments.AddRange(departments);
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 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"
},
};
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 == "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
},
};
context.CourseAssignments.AddRange(courseInstructors);
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();
//(Would get an error message if I don't add these beforehand) <!-- //tinfo200:[2021-03-10-rmatta2-dykstra1] - To view students.-->
if (context.Students.Any())
{
return; //(Would get an error message if I don't add these beforehand) <!-- //tinfo200:[2021-03-10-rmatta2-dykstra1] - Add DB for code.-->
}
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")
} //(Would get an error message if I don't add these beforehand) <!-- //tinfo200:[2021-03-10-rmatta2-dykstra1] - Add info for code.-->
};
foreach (Student s in students)
{
context.Students.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
} //(Would get an error message if I don't add these beforehand) <!-- //tinfo200:[2021-03-10-rmatta2-dykstra1] - Add info for code.-->
};
foreach (Course c in courses)
{
context.Courses.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
}, //(Would get an error message if I don't add these beforehand) <!-- //tinfo200:[2021-03-10-rmatta2-dykstra1] - Add info for code.-->
};
foreach (Enrollment e in enrollments)
{
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 = "Carlson", LastName = "On the Roof", EnrollmentDate = DateTime.Parse("2000-01-01")
},
new Student {
FirstMidName = "Mike", LastName = "Green", EnrollmentDate = DateTime.Parse("2001-01-01")
},
new Student {
FirstMidName = "Jack", LastName = "Red", EnrollmentDate = DateTime.Parse("2002-01-01")
},
new Student {
FirstMidName = "Jill", LastName = "Purple", EnrollmentDate = DateTime.Parse("2003-01-01")
},
};
foreach (Student s in students)
{
context.Students.Add(s);
}
var courses = new Course[]
{
new Course {
CourseId = 711, Title = "VBA", Credits = 3
},
new Course {
CourseId = 712, Title = "VBA102", Credits = 4
},
new Course {
CourseId = 713, Title = "VB.NET", Credits = 3
},
new Course {
CourseId = 714, Title = "C++", Credits = 3
},
};
foreach (Course c in courses)
{
context.Courses.Add(c);
}
var enrollments = new Enrollment[]
{
new Enrollment {
StudentId = 1, CourseId = 711, Grade = Grade.A
},
new Enrollment {
StudentId = 1, CourseId = 712, Grade = Grade.A
},
new Enrollment {
StudentId = 1, CourseId = 713, Grade = Grade.B
},
new Enrollment {
StudentId = 2, CourseId = 711, Grade = Grade.C
},
new Enrollment {
StudentId = 2, CourseId = 712
},
new Enrollment {
StudentId = 3, CourseId = 711
},
new Enrollment {
StudentId = 3, CourseId = 712, Grade = Grade.B
},
};
foreach (Enrollment e in enrollments)
{
context.Enrollments.Add(e);
}
context.SaveChanges();
}
public static void Initialize(SchoolContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Departments.Any())
{
return; // DB has been seeded
}
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();
// 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();
}