Sorting by NULLS FIRST

Sorting by NULLS FIRST

Postby 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
rdrenker
 
Posts: 3
Joined: Tue 22 Dec 2009 21:23

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle