You don't understand correctly: AR/NH works upon objects not tables. Without
any classes and mappings no one can show you any Criteria or HQL.
HQL is quite powerful, see here for example:
http://nhforge.org/doc/nh/en/index.html#queryhql-examples
Alternatively, if these queries are not part of
Hi Markus,
While I'm checking the HQL documentation that you sent, I've discovered the
AddEntity
method of CreateSQLQuery.
I think this is exactly the thing that I'm looking for.
Now I can run any SQL query that I want and map it to my object.
Of course, this is not the way that AR works.