private static async Task Seed_Database(ISchoolRepository repository)
{
if ((await repository.CountAsync <StudentModel, Student>()) > 0)
{
return;//database has been seeded
}
InstructorModel[] instructors = new InstructorModel[]
{
new InstructorModel {
FirstName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12"), EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new InstructorModel {
FirstName = "Kim", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11"), EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new InstructorModel {
FirstName = "Fadi", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06"), OfficeAssignment = new OfficeAssignmentModel {
Location = "Smith 17"
}, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new InstructorModel {
FirstName = "Roger", LastName = "Harui", HireDate = DateTime.Parse("1998-07-01"), OfficeAssignment = new OfficeAssignmentModel {
Location = "Gowan 27"
}, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new InstructorModel {
FirstName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15"), OfficeAssignment = new OfficeAssignmentModel {
Location = "Thompson 304"
}, EntityState = LogicBuilder.Domain.EntityStateType.Added
}
};
await repository.SaveGraphsAsync <InstructorModel, Instructor>(instructors);
DepartmentModel[] departments = new DepartmentModel[]
{
new DepartmentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Name = "English", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.FirstName == "Kim" && i.LastName == "Abercrombie").ID,
Courses = new HashSet <CourseModel>
{
new CourseModel {
CourseID = 2021, Title = "Composition", Credits = 3
},
new CourseModel {
CourseID = 2042, Title = "Literature", Credits = 4
}
}
},
new DepartmentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Name = "Mathematics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.FirstName == "Fadi" && i.LastName == "Fakhouri").ID,
Courses = new HashSet <CourseModel>
{
new CourseModel {
CourseID = 1045, Title = "Calculus", Credits = 4
},
new CourseModel {
CourseID = 3141, Title = "Trigonometry", Credits = 4
}
}
},
new DepartmentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Name = "Engineering", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.FirstName == "Roger" && i.LastName == "Harui").ID,
Courses = new HashSet <CourseModel>
{
new CourseModel {
CourseID = 1050, Title = "Chemistry", Credits = 3
}
}
},
new DepartmentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
Name = "Economics",
Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
InstructorID = instructors.Single(i => i.FirstName == "Candace" && i.LastName == "Kapoor").ID,
Courses = new HashSet <CourseModel>
{
new CourseModel {
CourseID = 4022, Title = "Microeconomics", Credits = 3
},
new CourseModel {
CourseID = 4041, Title = "Macroeconomics", Credits = 3
}
}
}
};
await repository.SaveGraphsAsync <DepartmentModel, Department>(departments);
IEnumerable <CourseModel> courses = departments.SelectMany(d => d.Courses);
CourseAssignmentModel[] courseInstructors = new CourseAssignmentModel[]
{
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Harui").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Calculus").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Harui").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
},
new CourseAssignmentModel {
EntityState = LogicBuilder.Domain.EntityStateType.Added,
CourseID = courses.Single(c => c.Title == "Literature").CourseID,
InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
},
};
await repository.SaveGraphsAsync <CourseAssignmentModel, CourseAssignment>(courseInstructors);
StudentModel[] students = new StudentModel[]
{
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Carson", LastName = "Alexander",
EnrollmentDate = DateTime.Parse("2010-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Contoso.Domain.Entities.Grade.A
},
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Contoso.Domain.Entities.Grade.C
},
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Macroeconomics").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Meredith", LastName = "Alonso",
EnrollmentDate = DateTime.Parse("2012-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Calculus").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
},
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Trigonometry").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
},
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Arturo", LastName = "Anand",
EnrollmentDate = DateTime.Parse("2013-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID
},
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
},
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Gytis", LastName = "Barzdukas",
EnrollmentDate = DateTime.Parse("2012-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Yan", LastName = "Li",
EnrollmentDate = DateTime.Parse("2012-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Composition").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Peggy", LastName = "Justice",
EnrollmentDate = DateTime.Parse("2011-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = courses.Single(c => c.Title == "Literature").CourseID,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Laura", LastName = "Norman",
EnrollmentDate = DateTime.Parse("2013-09-01")
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Nino", LastName = "Olivetto",
EnrollmentDate = DateTime.Parse("2005-09-01")
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Tom",
LastName = "Spratt",
EnrollmentDate = DateTime.Parse("2010-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = 1045,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Billie",
LastName = "Spratt",
EnrollmentDate = DateTime.Parse("2010-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = 1050,
Grade = Contoso.Domain.Entities.Grade.B
}
}
},
new StudentModel
{
EntityState = LogicBuilder.Domain.EntityStateType.Added,
FirstName = "Jackson",
LastName = "Spratt",
EnrollmentDate = DateTime.Parse("2017-09-01"),
Enrollments = new HashSet <EnrollmentModel>
{
new EnrollmentModel
{
CourseID = 2021,
Grade = Contoso.Domain.Entities.Grade.B
}
}
}
};
await repository.SaveGraphsAsync <StudentModel, Student>(students);
LookUpsModel[] lookups = new LookUpsModel[]
{
new LookUpsModel {
ListName = "Grades", Text = "A", Value = "A", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Grades", Text = "B", Value = "B", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Grades", Text = "C", Value = "C", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Grades", Text = "D", Value = "D", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Grades", Text = "E", Value = "E", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Grades", Text = "F", Value = "F", EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Credits", Text = "One", NumericValue = 1, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Credits", Text = "Two", NumericValue = 2, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Credits", Text = "Three", NumericValue = 3, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Credits", Text = "Four", NumericValue = 4, EntityState = LogicBuilder.Domain.EntityStateType.Added
},
new LookUpsModel {
ListName = "Credits", Text = "Five", NumericValue = 5, EntityState = LogicBuilder.Domain.EntityStateType.Added
}
};
await repository.SaveGraphsAsync <LookUpsModel, LookUps>(lookups);
}
