public static FXWinV2Entities BulkInserts <T>(this FXWinV2Entities context, T entity, int count, int batchSize) where T : class { context.Set <T>().Add(entity); if (count % batchSize == 0) { context.SaveChanges(); context.Dispose(); context = new FXWinV2Entities(); // This is optional context.Configuration.AutoDetectChangesEnabled = false; } return(context); }
public void SaveCollection <T>(IEnumerable <TObject> collection) { if (collection != null && collection.Count() > 0) { try { foreach (var item in collection) { //try //{ // //Add(item); _context.Set <TObject>().Add(item); // _context.SaveChanges(); //} //catch (Exception exp) //{ // throw; //} } _context.SaveChanges(); } catch (Exception) { throw; } } }