The following hql example is from the hibernate 2.0.3 doc:

select new Family(mother, mate, offspr)
from eg.DomesticCat as mother
join mother.mate as mate...

It seems to me that this statement will return collection of Family objects by constructing them using the fields returned from the query, but I cannot make this work for nhibernate, do I need to specify the assembly name of the class somewhere? do I need to create a mapping for the Family class? If I need to create a class it will be difficult because I use the class for reporting only therefore there is no mapping to the backend database.

When I'm trying to do is to use hql to construct "flattened" (or projected) report objects, is there another way to do that?

Thanks!

You need to put <import name="Fully.Qualified.Family, SomeAssembly" /> in one of your mapping files.

So, in other words, it isnt possible to do arbitrary ad-hoc type reporting without first defining the result "row" as a class?

Is that the only way to code up reports with (N)Hibernate?

Thanks!
-Michael