Here is a linq to sql query:

var query = db.Table1.Where(t => t.age >= 18); 
foreach (var item in query)
{
   ...
}

var query2 = query.Where(t => t.dept == 1234);
foreach (var item in query2)
{
     ...
} 

query and query2 are IQueryable objects. That means the sql queries are not executed until the foreach loop.

The previous code works fine. But i want to know how i can make this code async.

Here is what i’ve tried:

var query = db.Table1.Where(t => t.age >= 18); 
var res1 = await query.ToListAsync();
foreach (var item in res1)
{
   ...
}

var query2 = query.Where(t => t.dept = 1234);
var res2 = await query2.ToListAsync();
foreach (var item in res2)
{
     ...
} 

It works, but it is ugly to my eyes because i have to add 2 lines in my code.

So my question is: Is there a way to make the loop async ?

Something like that:

await foreach (var item in query2.ToListAsync())
{
   ...
}

Thanks

>Solution :

You can use the await keyword inside the foreach statement like so:

foreach (var item in await query2.ToListAsync())
{
   ...
}