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