public List <DemoData> LoadActiveDemoData3() { using (ProfilingSession.Current.Step("Biz.LoadActiveDemoData3")) { using (var dbContext = new DemoEFDbContext()) { var query = dbContext.DemoDatas.Where(item => item.IsActive); return(query.Select(item => new DemoData { Id = item.Id, Name = item.Name }).ToList()); } } }
public async Task TestSaveDemoDataAsync() { using (ProfilingSession.Current.Step("Biz.TestSaveDemoDataAsync")) { using (var dbContext = new DemoEFDbContext()) { var newItem = dbContext.DemoDatas.Create(); newItem.IsActive = true; newItem.Name = "new"; dbContext.DemoDatas.Add(newItem); await dbContext.SaveChangesAsync(); var items = dbContext.DemoDatas.Where(i => i.IsActive).OrderByDescending(e => e.Id).ToList(); dbContext.DemoDatas.Remove(items.First()); await dbContext.SaveChangesAsync(); } } }