select i.CompanyName from Company i
--> this will return all rows from company
if I include a property of an optional FK, no outer join is generated in the SQL, returning only rows where the FK is filled in:
select i.CompanyName, i.ParentCompany.CompanyName from Company i
--> Only companies with a parent company returned
simular issue as:
http://jira.nhibernate.org/browse/NH-141
I know this can be coded around using an outerjoin in HQL, but we are creating an easy way of displaying data. We would like to keep "from Company" and just specify which properties we want (at runtime, like "i.CompanyName", "i.ParentCompany.CompanyName").
Should this be a bug?
Thanks,
Geert