I've been fighting with this for some time now and I would like to understand the reasoning behind it. I realize that NHibernate (Hibernate) Criteria doesn't support arbitrary joins on columns that are not related through a mapped association. My problem is that I don't understand why this isn't possible (or necessary even). Because this isn't supported, there are many queries that are made more complicated, if they even possible.
Ex. (there is no mapped association between these tables) SELECT t1.* FROM table1 t1 WHERE t1.ID IN (SELECT t2.table1ID FROM table2) instead of SELECT t1.* FROM table1 t1, table2 t2 WHERE t1.ID=t2.tableID I know that HQL can be used to do this but as a C# developer I would prefer to expose a nice api to be able build these queries. Criteria is great for this, whereas HQL is not. I have a lot of SQL experience so I'll admit that I'm probably not be getting it because of the way I'm used to querying data. I would really like to understand what I'm missing here though. Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
