public static void Initialize(WebStoreContext context) { //context.Database.EnsureDeleted(); context.Database.EnsureCreated(); // Look for any products. if (context.Products.Any()) { return; // DB had already been seeded } var categories = new List <Category>() { new Category() { Id = 1, Name = "Sportswear", Order = 0, ParentId = null }, new Category() { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Category() { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Category() { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Category() { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Category() { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Category() { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Category() { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Category() { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Category() { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Category() { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Category() { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Category() { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Category() { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Category() { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Category() { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Category() { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Category() { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Category() { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Category() { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Category() { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Category() { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Category() { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Category() { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Category() { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Category() { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Category() { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Category() { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Category() { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Category() { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; using (var trans = context.Database.BeginTransaction()) { foreach (var section in categories) { context.Categories.Add(section); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] OFF"); trans.Commit(); } var brands = new List <Brand>() { new Brand() { Id = 1, Name = "Acne", Order = 0 }, new Brand() { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand() { Id = 3, Name = "Albiro", Order = 2 }, new Brand() { Id = 4, Name = "Ronhill", Order = 3 }, new Brand() { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand() { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand() { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; using (var trans = context.Database.BeginTransaction()) { foreach (var brand in brands) { context.Brands.Add(brand); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[ProductBrands] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[ProductBrands] OFF"); trans.Commit(); } var products = new List <Product>() { new Product() { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 0, CategoryId = 2, BrandId = 1 }, new Product() { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 1, CategoryId = 2, BrandId = 1 }, new Product() { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 2, CategoryId = 2, BrandId = 1 }, new Product() { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 3, CategoryId = 2, BrandId = 1 }, new Product() { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 4, CategoryId = 2, BrandId = 2 }, new Product() { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 5, CategoryId = 2, BrandId = 2 }, new Product() { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 6, CategoryId = 2, BrandId = 2 }, new Product() { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 7, CategoryId = 25, BrandId = 2 }, new Product() { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 8, CategoryId = 25, BrandId = 2 }, new Product() { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 9, CategoryId = 25, BrandId = 3 }, new Product() { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 10, CategoryId = 25, BrandId = 3 }, new Product() { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 11, CategoryId = 25, BrandId = 3 }, }; using (var trans = context.Database.BeginTransaction()) { foreach (var product in products) { context.Products.Add(product); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF"); trans.Commit(); } }
public static void Initialize(WebStoreContext context) { //Если базы данных не существует, то метод создаст ее, если база данных есть то не будет создавать context.Database.EnsureCreated(); if (context.Products.Any()) { return; } //Если база данных пустая, то заполним ее var _sections = new List <Section> { new Section() { Id = 1, Name = "SportsWear", Order = 0, ParentId = null }, new Section() { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Section() { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Section() { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Section() { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Section() { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Section() { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Section() { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Section() { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Section() { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Section() { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Section() { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Section() { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Section() { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Section() { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Section() { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Section() { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Section() { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Section() { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Section() { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Section() { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Section() { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Section() { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Section() { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Section() { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Section() { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Section() { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Section() { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Section() { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Section() { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; using (var trans = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections ON"); foreach (var section in _sections) { context.Sections.Add(section); } context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections OFF"); trans.Commit(); } var _brands = new List <Brand>() { new Brand() { Id = 1, Name = "Acne", Order = 0 }, new Brand() { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand() { Id = 3, Name = "Albiro", Order = 2 }, new Brand() { Id = 4, Name = "Ronhill", Order = 3 }, new Brand() { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand() { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand() { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; using (var trans = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands ON"); foreach (var brand in _brands) { context.Brands.Add(brand); } context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands OFF"); trans.Commit(); } var _products = new List <Product>() { new Product() { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 0, SectionId = 2, BrandId = 1 }, new Product() { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 1, SectionId = 2, BrandId = 1 }, new Product() { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 2, SectionId = 2, BrandId = 1 }, new Product() { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 3, SectionId = 2, BrandId = 1 }, new Product() { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 4, SectionId = 2, BrandId = 2 }, new Product() { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 5, SectionId = 2, BrandId = 2 }, new Product() { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 6, SectionId = 2, BrandId = 2 }, new Product() { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 7, SectionId = 25, BrandId = 2 }, new Product() { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 8, SectionId = 25, BrandId = 2 }, new Product() { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 9, SectionId = 25, BrandId = 3 }, new Product() { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 10, SectionId = 25, BrandId = 3 }, new Product() { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 11, SectionId = 25, BrandId = 3 }, }; using (var trans = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products ON"); foreach (var product in _products) { context.Products.Add(product); } context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products OFF"); trans.Commit(); } var _applicationUsers = new List <ApplicationUser>() { new ApplicationUser { Id = 1, FirstName = "Иван", SurName = "Иванов", Patronomic = "Иванов", Age = 22, Male = true }, new ApplicationUser { Id = 2, FirstName = "Петр", SurName = "Петров", Patronomic = "Петрович", Age = 27, Male = true }, new ApplicationUser { Id = 3, FirstName = "Сидор", SurName = "Сидоров", Patronomic = "Сидорович", Age = 12, Male = true } }; using (var trans = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Users ON"); foreach (var user in _applicationUsers) { context.ApplicationUsers.Add(user); } context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Users OFF"); trans.Commit(); } }
/// <summary> /// Наполняет таблицы БД начальными данными /// </summary> /// <param name="webStoreContext"></param> public static void Initialize(WebStoreContext webStoreContext) { //проверяет, создана ли БД (если нет, то создает ее? непонятно зачем, если нужно апдейтить через миграции, а не так) webStoreContext.Database.EnsureCreated(); //Проверяет - если есть хоть один элемент в таблице, то ничего не делаем if (webStoreContext.Products.Any()) { return; } //просто список с данными, которыми хотим напонить таблицу в базе List <Section> sections = new List <Section>() { new Section() { Id = 1, Name = "Sportswear", Order = 0, ParentId = null }, new Section() { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Section() { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Section() { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Section() { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Section() { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Section() { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Section() { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Section() { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Section() { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Section() { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Section() { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Section() { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Section() { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Section() { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Section() { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Section() { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Section() { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Section() { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Section() { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Section() { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Section() { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Section() { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Section() { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Section() { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Section() { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Section() { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Section() { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Section() { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Section() { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; //перенос данных в базу using (IDbContextTransaction transaction = webStoreContext.Database.BeginTransaction()) { //переносим данные из List в Context-таблицу foreach (Section section in sections) { webStoreContext.Sections.Add(section); } //следующие команды нужны для того, чтобы можно было сохранить в полях Id таблицы БД свои значения webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON"); //отключаем проверку внешних ключей webStoreContext.SaveChanges(); //сохраняем изменения, сделанные в Context, в БД webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF"); //сохраняем данные о проведенных изменениях? transaction.Commit(); } List <Brand> brands = new List <Brand>() { new Brand() { Id = 1, Name = "Acne", Order = 0 }, new Brand() { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand() { Id = 3, Name = "Albiro", Order = 2 }, new Brand() { Id = 4, Name = "Ronhill", Order = 3 }, new Brand() { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand() { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand() { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; using (var transaction = webStoreContext.Database.BeginTransaction()) { foreach (Brand brand in brands) { webStoreContext.Brands.Add(brand); } webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON"); webStoreContext.SaveChanges(); webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF"); transaction.Commit(); } List <Product> products = new List <Product>() { new Product() { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 0, SectionId = 2, BrandId = 1 }, new Product() { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 1, SectionId = 2, BrandId = 1 }, new Product() { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 2, SectionId = 2, BrandId = 1 }, new Product() { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 3, SectionId = 2, BrandId = 1 }, new Product() { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 4, SectionId = 2, BrandId = 2 }, new Product() { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 5, SectionId = 2, BrandId = 2 }, new Product() { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 6, SectionId = 2, BrandId = 2 }, new Product() { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 7, SectionId = 25, BrandId = 2 }, new Product() { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 8, SectionId = 25, BrandId = 2 }, new Product() { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 9, SectionId = 25, BrandId = 3 }, new Product() { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 10, SectionId = 25, BrandId = 3 }, new Product() { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 11, SectionId = 25, BrandId = 3 }, }; using (var transaction = webStoreContext.Database.BeginTransaction()) { foreach (Product product in products) { webStoreContext.Products.Add(product); } webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON"); webStoreContext.SaveChanges(); webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF"); transaction.Commit(); } }
public static void Initialize( WebStoreContext context) { context.Database.EnsureCreated(); // categories if (!context.Categories.Any()) { var categories = new List <Category> { new Category { Id = 1, Name = "Sportswear 2", Order = 0, ParentId = null }, new Category { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Category { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Category { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Category { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Category { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Category { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Category { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Category { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Category { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Category { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Category { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Category { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Category { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Category { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Category { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Category { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Category { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Category { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Category { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Category { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Category { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Category { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Category { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Category { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Category { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Category { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Category { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Category { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Category { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; using var trans = context.Database.BeginTransaction(); foreach (var section in categories) { context.Categories.Add(section); } context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Categories] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Categories] OFF"); trans.Commit(); } // brands if (!context.Brands.Any()) { var brands = new List <Brand> { new Brand { Id = 1, Name = "Acne", Order = 0 }, new Brand { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand { Id = 3, Name = "Albiro", Order = 2 }, new Brand { Id = 4, Name = "Ronhill", Order = 3 }, new Brand { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; using var trans = context.Database.BeginTransaction(); foreach (var brand in brands) { context.Brands.Add(brand); } context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Brands] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Brands] OFF"); trans.Commit(); } // products if (!context.Products.Any()) { var products = new List <Product> { new Product() { Id = 1, Name = "Pixel Infrared Thermal Imager", Price = 1025, ImageUrl = "product1.jpg", Order = 0, CategoryId = 2, BrandId = 1 }, new Product() { Id = 2, Name = "Mini Electric Welding Machine", Price = 1025, ImageUrl = "product2.jpg", Order = 1, CategoryId = 2, BrandId = 1 }, new Product() { Id = 3, Name = "Digital Microscope", Price = 1025, ImageUrl = "product3.jpg", Order = 2, CategoryId = 2, BrandId = 1 }, new Product() { Id = 4, Name = "USB Digital Storage Oscilloscope", Price = 1025, ImageUrl = "product4.jpg", Order = 3, CategoryId = 2, BrandId = 1 }, new Product() { Id = 5, Name = "Intelligent 2 in 1 Digital", Price = 1025, ImageUrl = "product5.jpg", Order = 4, CategoryId = 2, BrandId = 2 }, new Product() { Id = 6, Name = "Spindle Motor", Price = 1025, ImageUrl = "product6.jpg", Order = 5, CategoryId = 2, BrandId = 2 }, new Product() { Id = 7, Name = "Digits LED Display", Price = 1025, ImageUrl = "product7.jpg", Order = 6, CategoryId = 2, BrandId = 2 }, new Product() { Id = 8, Name = "Digital Oscilloscope", Price = 1025, ImageUrl = "product8.jpg", Order = 7, CategoryId = 25, BrandId = 2 }, new Product() { Id = 9, Name = "HD Intelligent Graphical Digital Oscilloscope Multimeter", Price = 1025, ImageUrl = "product9.jpg", Order = 8, CategoryId = 25, BrandId = 2 }, new Product() { Id = 10, Name = "Cordless Brushless", Price = 1025, ImageUrl = "product10.jpg", Order = 9, CategoryId = 25, BrandId = 3 }, new Product() { Id = 11, Name = "Smart Laser Engraver DIY", Price = 1025, ImageUrl = "product11.jpg", Order = 10, CategoryId = 25, BrandId = 3 }, new Product() { Id = 12, Name = "Intelligent Solar Pure Sine Wave Inverter", Price = 1025, ImageUrl = "product12.jpg", Order = 11, CategoryId = 25, BrandId = 3 } }; using var trans = context.Database.BeginTransaction(); foreach (var product in products) { context.Products.Add(product); } context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Products] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw( "SET IDENTITY_INSERT [dbo].[Products] OFF"); trans.Commit(); } }
private static void InitProducts(WebStoreContext webStoreContext) { var products = new List <Product> { new Product { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 0, CategoryId = 2, BrandId = 1 }, new Product { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 1, CategoryId = 2, BrandId = 1 }, new Product { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 2, CategoryId = 2, BrandId = 1 }, new Product { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 3, CategoryId = 2, BrandId = 1, IsNew = true }, new Product { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 4, CategoryId = 2, BrandId = 2, IsSale = true }, new Product { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 5, CategoryId = 2, BrandId = 2 }, new Product { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 6, CategoryId = 2, BrandId = 2 }, new Product { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 7, CategoryId = 25, BrandId = 2 }, new Product { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 8, CategoryId = 25, BrandId = 2 }, new Product { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 9, CategoryId = 25, BrandId = 3 }, new Product { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 10, CategoryId = 25, BrandId = 3 }, new Product { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 11, CategoryId = 25, BrandId = 3 } }; using (var transaction = webStoreContext.Database.BeginTransaction()) { foreach (var product in products) { webStoreContext.Products.Add(product); } webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON"); webStoreContext.SaveChanges(); webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF"); transaction.Commit(); } }
private static void InitCategories(WebStoreContext webStoreContext) { var categories = new List <Category> { new Category { Id = 1, Name = "Sportswear", Order = 0, ParentId = null }, new Category { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Category { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Category { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Category { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Category { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Category { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Category { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Category { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Category { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Category { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Category { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Category { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Category { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Category { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Category { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Category { Id = 17, Name = "Gucci", Order = 8, ParentId = 7 }, new Category { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Category { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Category { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Category { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Category { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Category { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Category { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Category { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Category { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Category { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Category { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Category { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Category { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; using (var transaction = webStoreContext.Database.BeginTransaction()) { foreach (var category in categories) { webStoreContext.Categories.Add(category); } webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] ON"); webStoreContext.SaveChanges(); webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] OFF"); transaction.Commit(); } }
private static void InitBrands(WebStoreContext webStoreContext) { var brands = new List <Brand> { new Brand { Id = 1, Name = "Acne", Order = 0 }, new Brand { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand { Id = 3, Name = "Albiro", Order = 2 }, new Brand { Id = 4, Name = "Ronhill", Order = 3 }, new Brand { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand { Id = 7, Name = "Rösch creative culture", Order = 6 } }; using (var transaction = webStoreContext.Database.BeginTransaction()) { foreach (var brand in brands) { webStoreContext.Brands.Add(brand); } webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON"); webStoreContext.SaveChanges(); webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF"); transaction.Commit(); } }