[Solved]-Can I use a IComparer in .OrderBy() in Linq-to-SQL?-LINQ,C#

it's not that the icomparer is not supported, it is that in linq-to-sql, an orderby() must be translated to a t-sql operation. if it allows you to specify criteria for comparisons, the c# code behind it would have to be executed by sql server to use it.

if you need to do something in linq-to-sql that is not supported but which can be done in t-sql, you can always get around it by using a stored procedure, which work splendidly with linq-to-sql. if that it inconvenient, you can call the tolist() method to invoke the execution and then sort it in memory. the practicality of this depends on the size of the data and how much of it you wished to fetch (such as when implementing pagination).