The litedb.queryable's discuss from mgernand

mgernand / litedb.queryable Goto Github PK

View Code? Open in Web Editor NEW

An IQueryable wrapper implementation for LiteDB with additional async extensions.

License: MIT License

C# 100.00%

litedb.queryable's Issues

OrderBy called once but applied multiple times

Hello,

I get the following exception when I use the same ordered query multiple times. It seems like the query builder tries to apply the ordering twice, once per call to Count instead of just once.
Is it a bug or am I missing something ?

Thank you for your time!

Reproduction:

LiteDatabase db = new("test.db");
ILiteCollection<TestObject> col = db.GetCollection<TestObject>();

IQueryable<TestObject> query = col.AsQueryable();
IOrderedQueryable<TestObject> orderedQuery = query.OrderBy(o => o.Field);

Console.WriteLine(orderedQuery.Count());
Console.WriteLine(orderedQuery.Count());

class TestObject
{
    public string Field { get; set; }
}

0
Unhandled exception. System.ArgumentException: ORDER BY already defined in this query builder             
   at LiteDB.LiteQueryable`1.OrderBy(BsonExpression keySelector, Int32 order)                             
   at LiteDB.Queryable.LiteQueryBuilder`1.ApplyOrderBy(Expression expression, Boolean isAsync)            
   at LiteDB.Queryable.LiteQueryBuilder`1.Execute[TResult](Expression expression, Boolean isAsync)        
   at LiteDB.Queryable.LiteQueryBuilder`1.Execute[TResult](Expression expression)                         
   at LiteDB.Queryable.LiteQueryProvider`1.Execute[TResult](Expression expression)                        
   at Program.<Main>$(String[] args)

"Include" throws NotSupportedException

Example code:

LiteDatabaseAsync database = new LiteDatabaseAsync("test.db");
ILiteCollectionAsync<Person> collection = database.GetCollection<Person>("people");
IQueryable<Person> queryable = collection.AsQueryable();
var result = queryable.Include(i => i.ChildItems).ToListAsync()