title: Performance Issue with NHibernate Query
body: <p>I am currently having a performance problem with the following query written in NHibernate. I am trying to transform the data I queried into DTO's. With this complex structure I cannot use QueryOver to transform the entities. On the other side Linq provider is so useful but it takes ~10 seconds to load and transform ~6000 entities with each 30 child items. It creates an SQL query with left outer join. Are there any other ways to write this query with a better approach? </p>
  
  <pre><code>var Entities = session.Query&lt;crmEntity&gt;()
           .Where(x =&gt; x.EntityType.ID == EntityType)
           .Select(entity =&gt; new EntityDTO()
           {
               ID = entity.ID,
               EntityType = entity.EntityType.ID,
               InstanceID = entity.Instance.ID,
               Values = entity.Values.Select(
                 value =&gt; new CustomFieldValueDTO()
               {
                   ID = value.ID,
                   FieldID = value.Field.ID,
                   Value = value.Value
               }).ToList&lt;CustomFieldValueDTO&gt;()
           }).ToList();
  </code></pre>