c# - How to add collation to Linq expressions? -

How to implement the method for IQuariable like below:

  var trash = ContextBase Db Order by user A.FirstName Select a). Collated List ();  

In a result I want to see SELECT * from [user] ORDER BY FirstName COLLATE SQL_SwedishStd_Pref_Cp1_CI_AS ASC

Thanks.

You can not extend the Linq-to-SQL implementation to implement new functionality.

The best you can do is implement a client-side collation.