Menu
I don't want to use array sorting on the web server it should be done on SQL server.
Microsoft does not support query(in EF) like this:
SELECT * FROM [Table_1]
ORDER BY [Table_1].field
COLLATE SQL_SwedishStd_Pref_Cp1_CI_AS
Any ideas? Thank you in advice...
725
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type.
By design, EF Core refrains from translating these overloads to SQL, and attempting to use them will result in an exception. For one thing, EF Core does know not which case-sensitive or case-insensitive collation should be used.
A case-insensitive collation ignores the differences between uppercase and lowercase letters for string comparison and sorting, whereas a case-sensitive collation does not. For example, in case-insensitive collation, “A” and “a” are equal.
So for example, Latin1_General_CI_AS is case-insensitive and accent-sensitive.
The Entity Framework does support a COLLATE clause in an ORDER BY in Entity SQL. I'm not aware of any way to do it with LINQ to Entities. Indeed, I don't know how to do it with any LINQ provider. I'm not sure it's possible.
56
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
