public void AddBulkWithoutPackage(IEnumerable <T> entities) { _entities.Configuration.AutoDetectChangesEnabled = false; int page = 1000; int skip = 0; int total = entities.Count(); IEnumerable <T> chnuckEntities; while (skip < total) { if (skip + page > total) { chnuckEntities = entities.Skip(skip); skip = total; } else { chnuckEntities = entities.Skip(skip).Take(page); skip += page; } var ctx = new AssetContext(); var tempDBSet = ctx.Set <T>(); ////////////////////// var newThread = new Task(() => { foreach (var e in chnuckEntities) { tempDBSet.Add(e); } ctx.SaveChanges(); }); // Start the task. newThread.Start(); // Output a message from the calling thread. Console.WriteLine("start thread to save bulk with page size'{0}'.", page); //newThread.Wait(); ///////////////////////// } _entities.Configuration.AutoDetectChangesEnabled = true; Save(); }
public List <Software> GetAllAssets() { return(context.Set <Software>().AsEnumerable()?.ToList()); }
public async Task <T> GetByIdAsync(int id) { return(await _context.Set <T>().FindAsync(id)); }
public List <Book> GetAllAssets() { return(context.Set <Book>().AsEnumerable()?.ToList()); }
protected BaseRepository(AssetContext ctx) { _ctx = ctx; _entitySet = ctx.Set <T>(); }