/// <summary>
/// 数据库无数据时,初始化一些数据给数据库
/// </summary>
/// <param name="context">数据库上下文</param>
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 = "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")
}
};
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
}
};
var enrollments = new Enrollment[]
{
new Enrollment {
StudentID = 1, CourseID = 1050, Grade = Grade.A
},
new Enrollment {
StudentID = 1, CourseID = 4022, Grade = Grade.C
},
new Enrollment {
StudentID = 1, CourseID = 4041, Grade = Grade.B
},
new Enrollment {
StudentID = 2, CourseID = 1045, Grade = Grade.B
},
new Enrollment {
StudentID = 2, CourseID = 3141, Grade = Grade.F
},
new Enrollment {
StudentID = 2, CourseID = 2021, Grade = Grade.F
},
new Enrollment {
StudentID = 3, CourseID = 1050
},
new Enrollment {
StudentID = 4, CourseID = 1050
},
new Enrollment {
StudentID = 4, CourseID = 4022, Grade = Grade.F
},
new Enrollment {
StudentID = 5, CourseID = 4041, Grade = Grade.C
},
new Enrollment {
StudentID = 6, CourseID = 1045
},
new Enrollment {
StudentID = 7, CourseID = 3141, Grade = Grade.A
},
};
context.AddRange(courses);
context.AddRange(students);
context.AddRange(enrollments);
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
};
var mathematics = new Department
{
Name = "Mathematics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = fakhouri
};
var engineering = new Department
{
Name = "Engineering",
Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = harui
};
var economics = new Department
{
Name = "Economics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
Administrator = kapoor
};
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)
{
// 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();
}