EF Core + SQLite order by decimal value [Answered]

Hey I tried to sort a query via a decimal column but I get this exception:

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.

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?

C#•4y ago•

3 replies

Dusty

EF Core + SQLite order by decimal value [Answered]

Hey I tried to sort a query via a decimal column but I get this exception:

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.

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.

EF Core + SQLite order by decimal value [Answered]

Similar Threads

EF Core + SQLite order by decimal value [Answered]

Similar Threads

Similar Threads

Similar Threads