Nested Query in Entity Framework
From Logic Wiki
Dim EarliestDate As DateTime = (From a In Absences
From d In a.Durations
Where Not d.Exported Select d.AbsenceDate).Min()
Duration is a subset of Absence