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