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
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.
How to set up a website and database using the Turnkey Linux LAMP stack
by johna | November 18, 2023
If you need to host your own website for the purposes of web development, Turnkey Linux LAMP Stack is an easy to install all-in-one solution that you can set up on a spare computer or a VM (Virtual Machine).
Comments
There are no comments yet. Be the first to leave a comment!