Order with the Collate Offer | Entity Framework Basics

Question

I do not want to use array sorting on the web server, this should be done on the SQL server.

Microsoft does not support the query (in EF) as follows:

SELECT * FROM [Table_1]
ORDER BY [Table_1].field
COLLATE SQL_SwedishStd_Pref_Cp1_CI_AS

Any ideas? Thank you for the consultation ...

Answer 1

Entity Framework supports the COLLATE clause in ORDER BY in Entity SQL . I do not know how to do this with LINQ to Entities. Indeed, I do not know how to do this with any LINQ provider. I am not sure if this is possible.