public static void Initialize(this MyWebStoreContext context) { context.Database.EnsureCreated(); if (context.Products.Any()) { return; } using (var transaction = context.Database.BeginTransaction()) { foreach (var section in TestData.Sections) { context.Sections.Add(section); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF"); transaction.Commit(); } using (var transaction = context.Database.BeginTransaction()) { foreach (var brand in TestData.Brands) { context.Brands.Add(brand); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF"); transaction.Commit(); } using (var transaction = context.Database.BeginTransaction()) { foreach (var product in TestData.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"); transaction.Commit(); } }
public SqlProductData(MyWebStoreContext db) => _db = db;
public UsersController(MyWebStoreContext db) => _userStore = new UserStore <User>(db)
public SqlOrderService(MyWebStoreContext db, UserManager<User> UserManager) { _db = db; _UserManager = UserManager; }