http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Allen, That is something that I added to NHibernate, Hibernate has no equivalent that I know of http://ayende.com/2580/efficently-loading-deep-object-graphs#comment12http://ayende.com/2580/efficently-loading-deep-object-graphs#comment12Thu, 05 Jul 2007 20:59:29 GMTI'm wondering what is the Hibernate equivalent syntax for achieving this since there's no CreateMultiQuery() function? http://ayende.com/2580/efficently-loading-deep-object-graphs#comment11http://ayende.com/2580/efficently-loading-deep-object-graphs#comment11Thu, 05 Jul 2007 20:40:45 GMTYes, it should be http://ayende.com/2580/efficently-loading-deep-object-graphs#comment10http://ayende.com/2580/efficently-loading-deep-object-graphs#comment10Sat, 30 Jun 2007 16:50:48 GMTI may be mistaken, but shouldn't the line: .SetEntity("policy", Policy) be .SetInt32("policyId", policyId) http://ayende.com/2580/efficently-loading-deep-object-graphs#comment9http://ayende.com/2580/efficently-loading-deep-object-graphs#comment9Sat, 30 Jun 2007 16:10:32 GMT@ Florent, Yes, that would be faster, but the key part here is that it is 5 request, but a SINGLE round trip http://ayende.com/2580/efficently-loading-deep-object-graphs#comment8http://ayende.com/2580/efficently-loading-deep-object-graphs#comment8Thu, 21 Jun 2007 09:57:22 GMTOk, if I understand well, you mean it's faster to do 5 requests with only one join between two tables in each request instead of one big request between the 6 tables ? BTW, I forgot the .Add(new EqExpression("Id", policyId)) between CreateCritera and the first SetFetchMode for removing the Cartesian product. @Sven : yeah, damn fast ! ;) http://ayende.com/2580/efficently-loading-deep-object-graphs#comment7http://ayende.com/2580/efficently-loading-deep-object-graphs#comment7Thu, 21 Jun 2007 09:08:46 GMTDamn, he's just too quick, isn't he ? :-) http://ayende.com/2580/efficently-loading-deep-object-graphs#comment6http://ayende.com/2580/efficently-loading-deep-object-graphs#comment6Thu, 21 Jun 2007 08:57:59 GMTFlorent, I'm guessing what you wrote would cause the huge cartesian product Ayende mentioned. http://ayende.com/2580/efficently-loading-deep-object-graphs#comment5http://ayende.com/2580/efficently-loading-deep-object-graphs#comment5Thu, 21 Jun 2007 08:56:48 GMTThis will return a single result set. The problem with that is that if you try to load all of that in a single result set, you will have a big Cartesian product. The approach above uses separate queries, but only a single round trip http://ayende.com/2580/efficently-loading-deep-object-graphs#comment4http://ayende.com/2580/efficently-loading-deep-object-graphs#comment4Thu, 21 Jun 2007 08:55:26 GMTSorry for my ignorance, but what's the difference with adding "SetFetchMode" ? IList list = Session.CreateCriteria(typeof (Policy )) .SetFetchMode("PolicyLeadAssociations", FetchMode.Join) .SetFetchMode("PolicyEmployeeAssociations", FetchMode.Join) .SetFetchMode("PolicyManagerAssociations", FetchMode.Join) .SetFetchMode("PolicyDepartmentAssociations", FetchMode.Join) .SetFetchMode("PolicyCustomerAssociations", FetchMode.Join) .List(); http://ayende.com/2580/efficently-loading-deep-object-graphs#comment3http://ayende.com/2580/efficently-loading-deep-object-graphs#comment3Thu, 21 Jun 2007 08:53:37 GMTI mean, that is one option that you have, yes. http://ayende.com/2580/efficently-loading-deep-object-graphs#comment2http://ayende.com/2580/efficently-loading-deep-object-graphs#comment2Wed, 20 Jun 2007 21:07:49 GMTYou mean... there are o/r mappers out there which fetch graphs using cartesian products? :X Ugh... http://ayende.com/2580/efficently-loading-deep-object-graphs#comment1http://ayende.com/2580/efficently-loading-deep-object-graphs#comment1Wed, 20 Jun 2007 21:01:20 GMT