.ToListAsync() not found when using WhereIf

Question

I am reading this tutorial. I want to use async query with EF Core.

It works well when i use like this:

var tasks = await _taskRepository
    .GetAll()
    //.WhereIf(!string.IsNullOrEmpty(input?.Title), x => x.Title.Contains(input.Title))
    //.WhereIf(input?.State != null, x => x.State == input.State.Value)
    //.OrderByDescending(x => x.CreationTime)
    .ToListAsync();

but i want to use whereif and orderby like

var tasks = await _taskRepository
    .GetAll()
    .WhereIf(!string.IsNullOrEmpty(input?.Title), x => x.Title.Contains(input.Title))
    .WhereIf(input?.State != null, x => x.State == input.State.Value)
    .OrderByDescending(x => x.CreationTime)
    .ToListAsync();

Error:

'IOrderedEnumerable' does not contain a definition for 'ToListAsync' and no extension method 'ToListAsync' accepting a first argument of type 'IOrderedEnumerable' could be found (are you missing a using directive or an assembly reference?)

score 8 · Accepted Answer · answered May 05 '18 at 18:23

You are using wrong WhereIf extension, it's easy to miss because you need to add extra using Visual Studio won't offer.

You are using extension which returns IEnumerable

Abp.Collections.Extensions.EnumerableExtensions.WhereIf<T>()

You need to use extension that returns IQueryable

Abp.Linq.Extensions.QueryableExtensions.WhereIf<T>()

It's an easy fix, just add at the top of the file using Abp.Linq.Extensions;

score 2 · Answer 2 · answered May 05 '18 at 18:06

IOrderedEnumerable<Task> means that you are working with a IEnumerable<Task>.

Entity Framework Core works with IQueryable<T> (which represents a database query), not IEnumerable<T> (which represents an in-memory collection). As soon as the IQueryable<T> is converted to a IEnumerable<T>, the query is executed on the database server and the result retrieved.

So: if you are calling a method that returns IEnumerable<T>, that method was not made to be used in LINQ to Entities.

.ToListAsync() not found when using WhereIf

2 Answers2