~~Imagine I have (pseudo tables)
A
{
Id,
SomeDate Date
}
B
{
A.Id,
C.Id
}
C
{
Id,
StartDate Date,
EndDate Date,
}
Now I'd like to fetch A and prefetch C, like pseudo
[code]
A.WithPath(aPath => aPath
.Prefetch<CEntity>(a => a.CCollectionViaB)
.FilterOn(only C where A.SomeDate between C.StartDate and C.EndDate)
)
[/code]
The problem is FilterOn where I can't reach A.SomeDate.~~
Nevermind, forget it. I have to think a bit more about this one -