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
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).
Intermittent "Unable to read data from the transport connection: net_io_connectionclosed" errors
by johna | May 6, 2020
If you are having intermittent problems sending email in .NET using System.Net.Mail consider switching libraries.
Comments
There are no comments yet. Be the first to leave a comment!