Linq to SQL - Order By Nulls Last
Using Linq to SQL and need to order by NULLS last?
The following C# example orders by the field MyColumn ascending and keeps rows where MyColumn is NULL last.
The following C# example orders by the field MyColumn ascending and keeps rows where MyColumn is NULL last.
var result = from a in dc.MyTable
orderby (a.MyColumn == null) ascending, a.MyColumn ascending
select a;
Related Posts
Another pointless project - the programmable digital watch
by johna | January 20, 2025
I've come up with yet another pointless project. Would you like a watch that you could program yourself - but not a "smart watch"?
Converting dBase IV programs to run in the browser
by johna | September 13, 2024
Some pointless entertainment trying to get some old dBase programs running in the browser.
How to set up a debugging using the Turnkey Linux LAMP stack and VS Code
by johna | December 19, 2023
The second part in my guide to setting up a website and database using the Turnkey Linux LAMP stack.
Comments
There are no comments yet. Be the first to leave a comment!