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.

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?

https://github.com/dotnet/efcore/issues/18593
Seems you can add a conversion to double and that'll do the trick

Thanks that works!

✅ This post has been marked as answered!