Order by with Collate clause | Entity Framework

Question

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...

Answer 1

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.