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].
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.
