I have three related tables
List
Task (ref ListID)
TaskExecuted (ref TaskID)
in a linq query I'd like to check if any TaskExecuted records exists for a List.
I trying various variations of this:
var result = from l in metaDat.List select new
{
l.List, l.ListID,
TaskCount = l.Task.Count(),
AnyExecutedTasks = l.Task.TaskExecuted.Any()
}
Is it at all possible to navigate this way?