public static void Initialize(SalesContext context)
{
context.Database.EnsureCreated();
if (context.Products.Any())
{
return;
}
context.Products.AddRange(SeedData.Products().ToArray());
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Products ON");
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Products OFF");
}
finally
{
context.Database.CloseConnection();
}
context.Orders.AddRange(SeedData.Orders().ToArray());
context.Database.OpenConnection();
try
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Orders ON");
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Orders OFF");
}
finally
{
context.Database.CloseConnection();
}
}
protected override void Seed(SalesContext context)
{
context.Products.AddOrUpdate(k => k.Id, SeedData.Products().ToArray());
context.Orders.AddOrUpdate(k => k.Id, SeedData.Orders().ToArray());
}
