C
C#•2y ago
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. 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?
3 Replies
Angius
Angius•2y ago
https://github.com/dotnet/efcore/issues/18593 Seems you can add a conversion to double and that'll do the trick
Dusty
Dusty•2y ago
Thanks that works!
Accord
Accord•2y ago
✅ This post has been marked as answered!
Want results from more Discord servers?
Add your server
More Posts
Rider suggestion - creating a property for a DateTime field will introduce struct copyingI encountered this warning from Rider recently when refactoring some old code. I had a class with seCan someone explain this for me```cs namespace CSharp { internal class Program { static void Main(string[] args) ``HashCode randomly changing on structures.I've never in my career of coding have seen the behavior I'm about to describe so I'm hoping to learCOMException on Windows.Storage.Pickers.FolderPickerI am receiving the error `Error HRESULT E_FAIL has been returned from a call to a COM component` wheLinq Where JsonSerialization not workingHey, is there a way to get the following running: ```cs dbSet.Set<Table>().Where(x => JsonSerializerMicrosoft's DI Hierarchically controlled lifetime manager? [Answered]With Microsoft's DI, what's the equivalent of hierarchically controlled lifetime manager? The situatDisable bootstrap multiselect options after selectingHi. I have a bootstrap `<select multiple/>`. When one is selected, I want to disable all other selecReading ConfigurationSay I have a class like this: ```cs public StepGenerator(MigrationSteps migration) {