Oh, just read Ayende's blog and it looks like they're applied to the SQL, so I did misunderstand.
On Tuesday, January 22, 2013 7:43:49 AM UTC, Oskar Berggren wrote: > > To filter the records loaded for a collection (that you access by > navigation, as opposed to querying for the collection elements > directly), you should use the filter feature > (http://nhforge.org/doc/nh/en/index.html#filters). > > /Oskar > > > 2013/1/21 Richard <[email protected] <javascript:>>: > > Hi > > > > I want to apply a criteria to some child records that I am fetching. > This is > > my query > > > > var result = (from workItem in session.Query<WorkItem>() > > .FetchMany(x => x.Reports) > > .ThenFetchMany(y => y.ReportRows.Where(z > => > > z.Student.StudentID == "@111111")) > > where workItem.Id == 1 > > select workItem); > > > > I'm new to LINQ so trying to learn as I go along, but I would have > thought > > (he says... :) that the Where clause (z => z.StudentID .....) would > allow me > > to limit the 'ReportRow(s)' to just those which have a Student with the > ID > > of "@111111". > > > > I think I know how I can do the same query in QueryOver but should I be > able > > to do this in LINQ too? > > > > BTW I get this when I try and run it: > > > > System.Reflection.TargetInvocationException: Exception has been thrown > by > > the target of an invocation. ---> System.ArgumentException: A fetch > request > > must be a simple member access expression; '[100002]' is a > > SubQueryExpression instead. > > > > Thanks > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "nhusers" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/nhusers/-/BiJYsi9RyY8J. > > To post to this group, send email to [email protected]<javascript:>. > > > To unsubscribe from this group, send email to > > [email protected] <javascript:>. > > For more options, visit this group at > > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/FXVJP7bdoWMJ. 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.
