title: NHibernate one to many with LazyLoad off result in n+1 query
body: <p>i am trying to <strong>turn off</strong> lazyloading for <strong>one-to-many</strong> mapping in NHibernate. I have the follow mapping in my entity mapping class. An entity has many addresses, and what I was looking for is one query that basically join the base table to the Addresses table and return me all the result in one request. Instead I see a series of sql query submitted to database for each record in the base table.</p>
  
  <pre><code>HasMany(m =&gt; m.Addresses).Not.LazyLoad().Fetch.Join();
  </code></pre>
  
  <p>i need a way to turn off lazyloading completely.</p>