I think you should be able to call Fetch or Cachceable in any position
(before or after any Where/Take etc).  I really can't see why this
makes a difference.

On Dec 30, 2:46 pm, ooo <[email protected]> wrote:
> i am trying to get this query working using nhibernate 3.0 LINQ
>
> i have this which works fine . .
>
> IEnumerable<Project> list = Session.Query<Project>().FetchMany(r =>
> r.ProjectSponsors).ThenFetch(r => r.Sponsor);
>
> but i need to add a filter on it on the Sponsor.Name field, so i need
> something like this:
>
> IEnumerable<Project> list = Session.Query<Project>().FetchMany(r =>
> r.ProjectSponsors).ThenFetch(r => r.Sponsor).Where(r=>r.Name ==
> "Joe");
>
> but this fails as you need to put fetches at the end
>
> is there anyway to support putting a where clause on an entity that is
> loaded via "ThenFetch()"

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to