public static async Task Initialize(DatabaseContext context)
{
await WaitForDb(context);
context.Database.Migrate();
context.Database.EnsureCreated();
// Look for any students.
if (context.Students.Any())
{
return; // DB has been seeded
}
var users = new AspNetUser[]
{
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
};
foreach (var s in users)
{
await context.Users.AddAsync(s);
}
await context.SaveChangesAsync();
var students = new Student[]
{
new Student {
FirstName = "Carson", LastName = "Alexander",
AspNetUserId = users.Single(s => s.Username == "Administrator").Id,
},
new Student {
FirstName = "Meredith", LastName = "Alonso",
AspNetUserId = users.Single(s => s.Username == "meredith12").Id,
},
new Student {
FirstName = "Arturo", LastName = "Anand",
AspNetUserId = users.Single(s => s.Username == "Arturo").Id,
},
new Student {
FirstName = "Gytis", LastName = "Barzdukas",
AspNetUserId = users.Single(s => s.Username == "Gytis").Id,
},
new Student {
FirstName = "Yan", LastName = "Li",
AspNetUserId = users.Single(s => s.Username == "Yan").Id,
},
new Student {
FirstName = "Peggy", LastName = "Justice",
AspNetUserId = users.Single(s => s.Username == "Peggy").Id,
},
new Student {
FirstName = "Laura", LastName = "Norman",
AspNetUserId = users.Single(s => s.Username == "Laura").Id,
},
new Student {
FirstName = "Nino", LastName = "Olivetto",
AspNetUserId = users.Single(s => s.Username == "Nino").Id,
}
};
foreach (Student s in students)
{
await context.Students.AddAsync(s);
}
await context.SaveChangesAsync();
var courses = new Course[]
{
new Course {
Title = "Chemistry", Credits = 3,
},
new Course {
Title = "Microeconomics", Credits = 3,
},
new Course {
Title = "Macroeconomics", Credits = 3,
},
new Course {
Title = "Calculus", Credits = 4,
},
new Course {
Title = "Trigonometry", Credits = 4,
},
new Course {
Title = "Composition", Credits = 3,
},
new Course {
Title = "Literature", Credits = 4,
},
};
foreach (Course c in courses)
{
await context.Courses.AddAsync(c);
}
await context.SaveChangesAsync();
}
public static async Task Initialize(SchoolContext context)
{
await WaitForDb(context);
context.Database.Migrate();
context.Database.EnsureCreated();
// Look for any students.
if (context.Orders.Any())
{
return; // DB has been seeded
}
var users = new AspNetUser[]
{
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
new AspNetUser()
{
Username = "******", Password = "******"
},
};
foreach (var s in users)
{
await context.Users.AddAsync(s);
}
await context.SaveChangesAsync();
await context.Database.ExecuteSqlCommandAsync("DELETE FROM Student WHERE 1=1;");
var orders = new Order[]
{
new Order {
FirstName = "Cooper", LastName = "Sheldon", //Id = 0,
AspNetUserId = users.Single(s => s.Username == "Admin").Id,
},
new Order {
FirstName = "Hofstadter", LastName = "Leonard", //Id = 1,
AspNetUserId = users.Single(s => s.Username == "Temp").Id,
},
new Order {
FirstName = "Wolowitz", LastName = "Howard", //Id = 2,
AspNetUserId = users.Single(s => s.Username == "Guest").Id,
},
new Order {
FirstName = "Koothrappali", LastName = "Raj", //Id = 3,
AspNetUserId = users.Single(s => s.Username == "Guest2").Id,
},
};
foreach (Order s in orders)
{
await context.Orders.AddAsync(s);
}
await context.SaveChangesAsync();
}
