Ever want to sort your result set but make sure the records with a null sorting column appear last?
See the example below
var results = (from x in EntityObjectContext.MyTable
mydata = grp,
myid = grp.id,
mysortingentity = grp.mysortingentity
).OrderBy(x => sortingcolumn == null).ThenBy(x => x.mysortingentity.Name).ThenBy(x => x.myid);
Watch this space, this can easily be transformed into a Extension Method. Check out this link http://tahirhassan.blogspot.com/2010/06/linq-to-sql-order-by-nulls-last.html, this Extension method works for LinqToSQL.