There seems to be a behavior difference in filtering when AsQueryable() is used. Using this._sessionCollection as a IRedisCollection<> with CachedExpires and CachedRenewed are [Indexed]
var list = await this._sessionCollection.ToListAsync();
var filteredList = list.AsQueryable()
.Where(x => x.CachedExpires < now || x.CachedRenewed < currentKeyActivationDate)
.OrderBy(x => x.CacheKey)
.Take(count)
.ToList();
The filteredList count is 6, but:
var results = this._sessionCollection.AsQueryable()
.Where(x => x.CachedExpires < now || x.CachedRenewed < currentKeyActivationDate)
.OrderBy(x => x.CacheKey)
.Take(count)
.ToList();
The results count is zero.
There seems to be a behavior difference in filtering when
AsQueryable()is used. Usingthis._sessionCollectionas aIRedisCollection<>withCachedExpiresandCachedRenewedare[Indexed]The
filteredListcount is 6, but:The
resultscount is zero.