Nhibernate is an o(bject)/r mapper. Hql is a query language where you query for objects not db tables (nor db columns).
I suggest you to read the manual to give you a good understanding of what nh is. You can find it here http://nhforge.org/doc/nh/en/index.html Depending of what you're trying to do, you probably want something like select a from EntityA a left join a.EntityBCollection b or select new NamePrice(a.Name, b.Price) from EntityA a left join a.EntityBCollection b /Roger -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of similitude2009 Sent: den 9 april 2009 11:55 To: nhusers Subject: [nhusers] Left outer join in hql How can i do left outer join in hql ? oQuery.CreateQuery("Select a.Name,b.Price from TableA a LEFT OUTER JOIN TableB b ON a.Id = b.Id") does not work. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
