Aw: Re: Aw: ActiveRecord Inner Query

2011-06-08 Thread Markus Zywitza
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

Re: Aw: Re: Aw: ActiveRecord Inner Query

2011-06-08 Thread Erdem
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.