EF Core + SQLite order by decimal value [Answered]
Hey I tried to sort a query via a decimal column but I get this exception:
I searched a bit an people were speaking about using custom collations. Sadly I haven't found anything else about this yet.
I also tried client evaluation but this just takes too long as my table has several million entries :/
Any ideas on this?
System.NotSupportedException: SQLite does not support expressions of type 'decimal' in ORDER BY clauses. Convert the values to a supported type, or use LINQ to Objects to order the results on the client side.I searched a bit an people were speaking about using custom collations. Sadly I haven't found anything else about this yet.
I also tried client evaluation but this just takes too long as my table has several million entries :/
Any ideas on this?
