Demand Loading

I wish there was a way to demand load nested associations.  If you allow lazy load to work it will take forever to call the database for each association progressively. If I call the database directly and load the items it is much faster but I am afraid that new/unsaved items will not be returned in the query.

example

<code>

         private IEnumerable<PartDef> Parts
        {
            get
            {
                if(this.UnitOfWork != null)
                {
                    var extra = this;
                    var work = UnitOfWork;
                    var q = from t in work.Query<PartDef>()
                            where t.Assemblie.Drawing.Extra == extra
                            select t;
                    return q;//scared of missing new items
                }
                return this.Drawings.SelectMany(d => d.Assemblies.SelectMany(a => a.Parts));//very very slow

            }
        }

</code>

 On this same note I have had a related problem for some time and it has resurfaced again.

When I pass my entities off to my report engine on even my Xceed DataGridControl they seem to look at the values for all the properties in the entity. with lazy loaded associations this is a real slow process.

My Solution was to wrap the Entities into another class that only exposes the properties relevent to the given task. This solves the speed issue but sure makes development a pain. I have talked to the component makers and they seem to think the problem is on my end not theirs. ( I will be chatting with them again)

Does anyone see or have a better more flexible way of doing this so I dont have to double code my Entities with wrapper classes?