In Hibernate for Java we can write a named query in "hbm.xml" and select diferents properties from diferents entities and retrieve a collection of a specific class result for mapping this query. It is like:

select MyNamespace.MyResult(classA.propertyA, classB.propertyB)
from classA........

It works in java, but in .net I got "class not found: MyResult...."

Has the NHibernate suport for this feature? What I have to do?

thanks!

I found other way to do the same thing...

The solution is select in named query the properties from diferents entities that I want, and then in the execute method I configure the "SetResultTransformer" in IQuery:

public IList ExecuteCustomQuery(string queryName, string[] parameterNames, object[] parameterValues, Type resultType)
{

AliasToBeanConstructorResultTransformer res = new AliasToBeanConstructorResultTransformer(resultType.GetConstructors()[0]);

IQuery query = NHibernateSession.GetNamedQuery(queryName).SetResultTransformer(res);