public async Task BulkInsert(IList <EventHistory> inserting) { using (var model = new gb_dvsstagingEntities()) { model.Configuration.AutoDetectChangesEnabled = false; model.Configuration.ValidateOnSaveEnabled = false; model.Database.CommandTimeout = CONNECTION_TIMEOUT; // will add by counter events for (int i = 0; i <= inserting.Count() / INSERT_COUNT; i++) { var subHistories = inserting.Skip(i * INSERT_COUNT).Take(INSERT_COUNT).ToList(); var histories = subHistories.Select(NewRepositoryEventHistoryFrom).ToList(); model.dvs_eventhistory.AddRange(histories); await model.SaveChangesAsync(); } } }