public void SeedPersons(InterviewTestDbContext context)
{
var group1 = context.Groups.Where(r => r.GroupId == 1).FirstOrDefault();
var group2 = context.Groups.Where(r => r.GroupId == 2).FirstOrDefault();
var persons = new[]
{
new Person {
GroupId = 1, Group = group1, Fullname = "Asad Mahmood", DateTimeAdded = DateTime.Now
},
new Person {
GroupId = 1, Group = group1, Fullname = "Ben Clarke", DateTimeAdded = DateTime.Now
},
new Person {
GroupId = 2, Group = group2, Fullname = "Laura Smith", DateTimeAdded = DateTime.Now
},
new Person {
GroupId = 2, Group = group2, Fullname = "Helen Hayes", DateTimeAdded = DateTime.Now
},
new Person {
GroupId = 2, Group = group2, Fullname = "Robin Walker", DateTimeAdded = DateTime.Now
}
};
context.Persons.AddRange(persons);
context.SaveChanges();
}
public void SeedEverything(InterviewTestDbContext context)
{
context.Database.EnsureCreated();
if (context.Persons.Any())
{
return; //the database has been seeded
}
SeedGroups(context);
SeedPersons(context);
}
public void SeedGroups(InterviewTestDbContext context)
{
var groups = new[]
{
new Group {
Name = "Foo"
},
new Group {
Name = "Bar"
}
};
context.Groups.AddRange(groups);
context.SaveChanges();
}
public static void Initialize(InterviewTestDbContext context)
{
var initializer = new InterviewTestDbInitializer();
initializer.SeedEverything(context);
}