转换方法以等待查询完成
本文关键字:查询 等待 转换方法 | 更新日期: 2023-09-27 18:36:35
我正在使用下面的查询从数据库中加载一些数据。我是否可以使用此方法等待,直到此查询使用 await-async 完成?
public static void LoadData()
{
using (MyEntities entities = new MyEntities())
{
List<Employee> Employees = (from d in entities.Employees
where d.Id > 100
select new Employee
{
Name = d.LastName + ", " + d.FirstName
DoB = d.dob
}).ToList();
}
}
实体框架有一个从EF 6.0开始的ToListAsync
方法,该方法返回一个Task<List<T>>
,允许您await
它。
是的,您可以使用此方法 http://msdn.microsoft.com/en-us/library/dn220262(v=vs.113).aspx;
public static async void LoadData()
{
using (MyEntities entities = new MyEntities())
{
List<Employee> Employees = await (from d in entities.Employees
where d.Id > 100
select new Employee
{
Name = d.LastName + ", " + d.FirstName
DoB = d.dob
}).AsQueryable().ToListAsync();
}
}
如果 MyEntities 是 DbContext,您可以使用
List<Employee> Employees =
await entities.Set<Employee>()
.Where(d => d.Id > 100)
.Select(
d =>
new Employee
{
Name = d.LastName + ", " + d.FirstName,
DoB = d.dob
}).ToListAsync();