Nhibernate eager fetch for children -> grand children

Question

Searching the net for this one for the past 2 hours. Any help is greatly appreciated. The scenario is like this, we have a Questionnaire, witch has Steps, each step has input sets, each input set has questions.

A simple QuestionnaireRepository.Session.Get(id) will further on result in multiple queries when accessing different collections. I was hoping I can get them all in one trip to the database.

Thanks,

PS. Of course we will want to have a small dataset :D

score 1 · Answer 1 · edited May 23 '17 at 12:26

1

I have gotten ok results with my solution from here: nhibernate : how to intialise child list objects

BUT for anything but the smallest datasets, this will not perform very well, and I would recommend to denormalize.

edited May 23 '17 at 12:26

Community

1
1

answered Feb 02 '11 at 20:49

asgerhallas

16,890
6
50
68

going 1 deep is fine, but how about 2 or 3 levels down ? like I what to do for input sets and then for questions ? – Calin Feb 02 '11 at 22:02
The solution I linked to goes 3 levels down. – asgerhallas Feb 03 '11 at 09:17

Nhibernate eager fetch for children -> grand children

1 Answers1