nhibernate - sort null at end

select x from MyClass x order by case when x.MyProperty is null then 1 else 0 end, x.MyProperty

SELECT * FROM myTable
WHERE ...
ORDER BY CASE WHEN myDate IS NULL THEN 1 ELSE 0 END, myDate;