コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }