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(); }