Hi,

I have stumbled upon a problem when setting up an objectdatasource with nhibernate with server-side sorting. I have a gridview which lists orders, and one of the columns displays the name of a customer if one is registered and if not it displays a text similar to "Private". In my gridview, this column have the sortexpression "o.Customer.Name".

The problem arises on orders which are not connected to any customers (this is a requirement on the application, we only track valid business customers, private customers are not registered), and the Customer property is null. When ordering on this property, these are not returned.

Does anyone have a suggestion how to solve this? Considering that the sorting are done on the server-side, I guess there are some SQL magic needed...