internal static void SeedData(StoreContext context)
{
try
{
var cust = new Customer()
{
Id = 1,
EmailAddress = "*****@*****.**",
Password = "******",
FullName = "Super Spy",
};
if (!context.Customers.Any())
{
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.Customers', RESEED, 0);");
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Customers" + " ON");
context.Customers.Add(cust);
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Customers" + " OFF");
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
}
}
});
}
if (!context.Categories.Any())
{
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.Categories', RESEED, 0);");
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Categories" + " ON");
context.Categories.AddRange(SampleData.GetCategories());
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Categories" + " OFF");
transaction.Commit();
}
});
}
if (!context.Products.Any())
{
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.Products', RESEED, 0);");
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Products" + " ON");
context.Products.AddRange(SampleData.GetProducts());
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Products" + " OFF");
transaction.Commit();
}
});
}
if (!context.Orders.Any())
{
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.Orders', RESEED, 0);");
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Orders" + " ON");
context.Orders.AddRange(SampleData.GetOrders());
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.Orders" + " OFF");
transaction.Commit();
}
});
}
if (!context.OrderDetails.Any())
{
var products = new List <Product>
{
context.Categories
.Include(c => c.Products).FirstOrDefault()?
.Products.Skip(3).FirstOrDefault(),
context.Categories.Skip(2)
.Include(c => c.Products).FirstOrDefault()?
.Products.Skip(2).FirstOrDefault(),
context.Categories.Skip(5)
.Include(c => c.Products).FirstOrDefault()?
.Products.Skip(1).FirstOrDefault(),
};
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.OrderDetails', RESEED, 0);");
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.OrderDetails" + " ON");
context.OrderDetails.AddRange(SampleData.GetOrderDetails(products));
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.OrderDetails" + " OFF");
transaction.Commit();
}
});
}
if (!context.ShoppingCartRecords.Any())
{
var products = new List <Product>
{
context.Categories.Skip(2)
.Include(c => c.Products).FirstOrDefault()?
.Products.Skip(1).FirstOrDefault()
};
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT ('Store.ShoppingCartRecords', RESEED, 0);");
IExecutionStrategy strategy = context.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.ShoppingCartRecords" + " ON");
context.ShoppingCartRecords.AddRange(SampleData.GetCart(products));
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Store.ShoppingCartRecords" + " OFF");
transaction.Commit();
}
});
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw;
}
}