Using ToListAsync on an IQueryable

Question

We have a simple database and we are trying to retrieve db records asynchronously with EntityFramework in an MVC5 application like so:

var result = await dbcontext.Emails.Where(e=>e.name.StartsWith("ask")).ToListAsync;
return View(result);

OR

var result = dbcontext.Emails.Where(e=>e.name.StartsWith("ask"));
return View(await result.ToListAsync());

However we do not even get the option of using the ToListAsync (only ToList) even though the Where clause produces an IQueryable. We are using EF6 of course. Any help would be greatly appreciated.

Possible duplicate: http://stackoverflow.com/questions/24453814/is-there-a-way-i-can-run-a-database-sqlquery-as-async/24454001 — Kirill Shlenskiy, Dec 01 '15 at 00:12
Yes it is. Sorry, but I did try to find an answer first prior to posting. — user2981411, Dec 01 '15 at 00:26

score 7 · Answer 1 · answered Dec 01 '15 at 01:12

7

The ToListAsync is an extension method defined in the class System.Data.Entity.QueryableExtensions

You are probably not importing the namespace...

e.g. using System.Data.Entity;

answered Dec 01 '15 at 01:12

C. Augusto Proiete

24,684
2
63
91

Thanks. I figured it out finally. – user2981411 Jan 31 '16 at 17:00

Using ToListAsync on an IQueryable

1 Answers1

Linked