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();
}
}
}
