internal static void UpdateItems(params object[] items) { using (FilamentContext ctx = new FilamentContext()) { foreach (var item in items) { if (item is IEnumerable enumerable) { foreach (var ele in enumerable) { ctx.Entry(ele).State = EntityState.Modified; ctx.Update(ele); } } else { ctx.Entry(item).State = EntityState.Modified; ctx.Update(item); } } ctx.SaveChanges(); } }
//protected override void OnModelCreating(ModelBuilder modelBuilder) //{ // modelBuilder.Entity<FilamentDefn>() // .HasOne(fd => fd.DensityAlias) // .WithOne(da => da.FilamentDefn) // .HasForeignKey<DensityAlias>(da => da.FilamentDefnId); // //modelBuilder.Entity<SpoolDefn>() // // .HasOne<VendorDefn>() // // .WithMany(sd=>sd.SpoolDefns) // // .HasForeignKey(sd=>sd.VendorDefnId); //} //public Setting GetSetting(Func<Setting,bool> func) //{ // if (func != null) // return Settings.FirstOrDefault(s => func(s)); // else // return null; //} internal static void AddAll(params object[] items) { using (FilamentContext context = new FilamentContext()) { foreach (object item in items) { if (item is IEnumerable enumerable) { foreach (var ele in enumerable) { context.Entry(ele).State = EntityState.Added; context.Add(ele); } } else { context.Entry(item).State = EntityState.Added; context.Add(item); } } context.SaveChanges(); } }
private static void SeedVendorData <TContext>(Setting setting, FilamentContext filamentContext) where TContext : DbContext, new() { System.Diagnostics.Debug.WriteLine("Seeding VendorDefns"); var seedVendors = DataDefinitions.Seed.InitialVendorDefinitions(); foreach (var item in seedVendors) { item.UpdateItem <TContext>(); } //System.Diagnostics.Debug.Assert(insertCount == seedVendors.Length, "Not all vendor definitions were inserted into the database."); setting.SetValue(AddVendorDefn); filamentContext.Entry(setting).State = EntityState.Modified; filamentContext.Update(setting); filamentContext.SaveChanges(); }