Nhibernate - Cannot fetch multiple collections in a single query

Question

I have a entity Recipe and it has 3 collections images, comments and ingredients. They are mapped as a bag.

For a website I want to load the recipe collections with the recipe i.e. not lazy load so I discovered I could do that using this query:

from Recipe r
left join fetch r.Images
left join fetch r.Ingredients
left join fetch r.Comments

But this gives an exception:

Cannot fetch multiple collections in a single query if one of them is a bag

So how do I not lazy load my recipe and have the collections loaded allowing for the fact that there may not be any rows in that collection? I'm new at this and need an explanation.

Samuel Goldenbaum · Accepted Answer · 2012-05-16 09:50:57Z

1

To avoid a Cartesian query. I would execute 3 queries all using futures and left outer joins.

answered May 16, 2012 at 9:50

Samuel Goldenbaum

19k20 gold badges74 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Răzvan Flavius Panda · Accepted Answer · 2013-03-13 11:24:42Z

1

Changing to Sets will allow this, but are you sure this is what you want to do?

'Fetch'ing multiple child collections in this way is potentially very bad for your system performance. You could very easily end up with a Cartesian product fetching many times the number of rows you need from the database.

Ayende points out the potential problem here

You might want to look at session.CreateMultiQuery() or session.CreateMultiCriteria() instead.

edited Mar 13, 2013 at 11:24

Răzvan Flavius Panda

22.3k19 gold badges121 silver badges178 bronze badges

answered Apr 14, 2009 at 13:36

Steve Willcock

27.1k4 gold badges47 silver badges40 bronze badges

Comments

Frederik Gheysels · Accepted Answer · 2009-04-14 13:13:14Z

0

Map the collections as a set.

A bag is a collection that can contain multiple copies of the same item.

answered Apr 14, 2009 at 13:13

Frederik Gheysels

57.2k12 gold badges103 silver badges156 bronze badges

Collectives™ on Stack Overflow

Nhibernate - Cannot fetch multiple collections in a single query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related