.WhereIf is converting an IQueryable<T> to IEnumerable<T> #2624

bilalhaidar created 7 years ago

Hi,

In an AppService, I have this code:

var query = _manager.Shelters
               .WhereIf(
                   !input.Filter.IsNullOrWhiteSpace(),
                   t =>
                       t.ShelterCode.ToLower().Contains(input.Filter.Trim().ToLower()) ||
                       t.ShelterSubCode.ToLower().Contains(input.Filter.Trim().ToLower())
               );

The _manager.Shelters is defined in the manager as:

public virtual IQueryable<Shelter> Shelters { get { return _repository.GetAll(); } }

Now, if I hover over query above, it says it is of type IEnumerable<Shelter>. I want it to stay IQueryable<Shelter> so that I can do additional filtering, sorting, etc.

I tried to remove (WhereIf), then if I hover over query it displays IQueryable<Shelter>

The same code used in TenantAppService, works fine there. Am I missing any namespace reference?

Thanks

.WhereIf is converting an IQueryable<T> to IEnumerable<T> #2624

3 Answer(s)