How to order by column with null values last in entity framework
entity-framework
Question
Does anyone know how to return an ordered list of strings with null values last? I have something like this:
using(var context = new DomainEntities())
{
var result = context.Users.OrderBy(u => u.LastName).ThenBy(u => u.FirstName);
}
My problem though is that this query returns null values before non-null values.
Any thoughts?
Accepted Answer
I would do:
using(var context = new DomainEntities())
{
var result = context.Users.OrderBy(u => u.LastName == null)
.ThenBy(u => u.LastName)
.ThenBy(u => u.FirstName == null)
.ThenBy(u => u.FirstName);
}
...which should produce reasonable SQL.
Popular Answer
I don't know if there's some switch somewhere that you can flip. Otherwise, the straight forward approach would probably be something along the lines of
using (var context = new DomainEntities())
{
var FirstPart = context.Users.Where(u => u.LastName != null);
var SecondPart = context.Users.Where(u => u.LastName == null);
var Result = FirstPart.Union(SecondPart);
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
