Linq to SQL - Order By Nulls Last

John Avis by | April 7, 2011 | ASP.NET Web Forms Databases Web Development

Using Linq to SQL and need to 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.

var result = from a in dc.MyTable
orderby (a.MyColumn == null) ascending, a.MyColumn ascending
select a;

Related Posts

Intermittent "Unable to read data from the transport connection: net_io_connectionclosed" errors

by John Avis | May 6, 2020

If you are having intermittent problems sending email in .NET using System.Net.Mail consider switching libraries.

500 Internal Server Error after migrating from IIS 7.5 to IIS 10

by John Avis | November 4, 2019

As support ends for Microsoft Windows Server 2008 I have recently gone through migrating some websites to a new server running Windows Server 2016 and IIS 10 but some of the websites did not work.

tagInput: A simple jQuery plugin for tag entry using Bootstrap 4

by John Avis | October 15, 2019

For a website project I needed a way to enter multiple tags. I just wanted something simple that I could easily modify to suit my own needs, so I wrote my own.


There are no comments yet. Be the first to leave a comment!

Leave a Comment



...random postings about web development and programming, Internet, computers and electronics topics.

I recommend ASPnix for web hosting and Crazy Domains for domain registration.


Get the latest posts delivered to your inbox.