I'm trying to do the following:


IQuery query = session.CreateSQLQuery("SELECT TITLE FROM TABLE")
.SetResultTransformer(Transformers.AliasToBean(typeof(ReportData))) ;

IList<ReportData> result = query.List<ReportData>();


NHibernate throw "Return types of SQL query were not specified"; what's wrong?

Thanks

Well, return types of the SQL query were not specified :) You have to use AddScalar/AddEntity to specify what that query is supposed to return.

But documentation say that

13.1.5. Returning non-managed entities

It is possible to apply an IResultTransformer to native sql queries. Allowing it to e.g. return non-managed entities.

sess.CreateSQLQuery("SELECT NAME, BIRTHDATE FROM CATS")
.SetResultTransformer(Transformers.AliasToBean(typeof(CatDTO)))

This query specified:
• the SQL query string
• a result transformer
The above query will return a list of CatDTO which has been instantiated and injected the values of NAME and

BIRTHNAME into its corresponding properties or fields.

Hmm, I will have to fix the documentation then.

Hello,

i had the same problem with Returning non-managed entities as swtechno.

But the following example works now fine for me:


Schema is a small class with one property.


My Problem now is that i can not aliased the database columnsname "TABLE_SCHEMA" to my property "Name", because now the propertyname is the same as the databasecolumn. this is not nice.


Is there a way and how can i do it?


Thanks Axel