Page 1 of 1

Sorting by NULLS FIRST

Posted: Mon 19 Jul 2010 22:46
by rdrenker
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

Posted: Wed 21 Jul 2010 11:38
by AndreyR
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.