Sorting by NULLS FIRST

rdrenker · Post by **rdrenker** » Mon 19 Jul 2010 22:46

I'm using LinqConnect 5.70.146.

I need to be able to sort by NULLS FIRST, ie:

--> ORDER BY UPPER(t2.xxxx) NULLS FIRST

Is there a way for me to specify that I want NULLS FIRST when doing an OrderBy(e => e.xxxx) operation using LinqConnect?

Roy

AndreyR · Post by **AndreyR** » Wed 21 Jul 2010 11:38

We are investigating the possibility of extending the OrderBy functionality.
I will let you know about the results of our investigation.
As a workaround, I recommend you to use the Query or ExecuteQuery method, just put the SQL you want to have as a parameter and you'll get a IEnumerable or IQueryable result correspondingly.