public static async Task SeedAsync(FCDbContext context) { //var context = serviceProvider.GetRequiredService<YourDbContext>(); context.Database.EnsureCreated(); var taxonomySeed = new List <Taxonomy> { new Taxonomy { Id = 1, Key = "DC1", Value = "abcx" }, new Taxonomy { Id = 2, Key = "DC2", Value = "abcy" }, new Taxonomy { Id = 3, Key = "DC3", Value = "abcz" }, }; var masterData = await context.Taxonomy.ToListAsync(); var removeList = masterData.Where(w => !taxonomySeed.Contains(w)).ToList(); if (removeList.Any()) { context.RemoveRange(removeList); } var addList = taxonomySeed.Where(w => !masterData.Contains(w)).ToList(); await context.AddRangeAsync(addList); await context.SaveChangesAsync(); await SeedMaster(context); }
private static async Task SeedMaster(FCDbContext context) { var masterSeed = new List <Master> { new Master { Id = 1, Key = "MS1", Value = "wweee1", TaxonomyId = 1 }, new Master { Id = 2, Key = "MS2", Value = "qqrrr2", TaxonomyId = 2, }, new Master { Id = 3, Key = "MS3", Value = "zzcc3", TaxonomyId = 3, }, }; var masterData = await context.Master.ToListAsync(); var removeList = masterData.Where(w => !masterSeed.Contains(w)).ToList(); if (removeList.Any()) { context.RemoveRange(removeList); } var addList = masterSeed.Where(w => !masterData.Contains(w)).ToList(); await context.AddRangeAsync(addList); await context.SaveChangesAsync(); }