http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Just grab the latest bits http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment3http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment3Mon, 19 Mar 2007 14:16:26 GMTI've been waiting for this feature a long time! Perfect! Can you please inform where to find this update? http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment2http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment2Mon, 19 Mar 2007 14:07:51 GMTWouldn't the following be just as efficient, without the chance of getting a huge Cartesian product? IList list = (IList)session.CreateMutliQuery() .Add("from Blog") .Add("select p from Post p left join p.Blog b") .Add("select c from Comment c left join c.Post p left join p.Blog b") .List()[0]; foreach (Blog blog in list) ... I'm a bit uncertain if I used the right syntax, I mostly use the query API, and the point with the joins is so you can add a where statement to the blog, and simply add the same statement in the other 2 queries to avoid pulling out other posts/comments. http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment1http://ayende.com/2228/performance-multiply-collections-fetch-with-nhibernate#comment1Mon, 19 Mar 2007 07:48:14 GMT