Load multiple collections with least queries

[simon.m.fox]

Hi

I have the following model structure

Contract -> IEnumerable<ContractInputSpotLine>

ContractInputSpotLine -> IEnumerable<ContractSpotLine>

I need to calculate a value for the contract which is based on values in the ContractSpotLine so need to load all ContractInputSpotLines with all related ContractSpotLines. Everything I try so far I seem to run in to cartesian product type issues. I am currently using Linq with Fetch, but wouldn't mind using the Criteria API either. Can anyone point me in the right direction to some decent documentation on this type of issue or provide some sample code to push me in the right direction. I've currently tried the following (which I found on stackoverflow)

Session.QueryOver<Contract>() 
       .Fetch(c => c.ContractInputSpotLines) 
       .Fetch(c => c.ContractInputSpotLines[0].ContractSpotLines) 

and something similar using JoinAlias and Future from http://stackoverflow.com/questions/5208991/nhibernate-lazy-loading-nested-collections-with-futures-to-avoid-n1-problem

[Oskar Berggren]

2012/2/29 simon.m.fox <simon...@gmail.com>:

> Hi
>
> I have the following model structure
>
> Contract -> IEnumerable<ContractInputSpotLine>
> ContractInputSpotLine -> IEnumerable<ContractSpotLine>
>

Have you experimented with batch sizes on the class and collection mappings?

/Oskar