How to order by column with null values last in 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?

Answer 1

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.

EDIT: explanation (taken from Craig's comment):

Because false sorts before true.

Answer 2

var result = context.Users.OrderBy(x => x.FirstName ?? x.LastName);