Return Only Child Entity Linq Entity Framework

Question

Given something like:

public class Parent
{
    public int Id { get; set; }
    public List<Child> Children { get; set; }
}

// There is no reference to the parent in the object model
public class Child
{
    public int Id { get; set; }
    public string MyProperty { get; set; }
}

is it possible to load only a child matching a particular condition, for a given Parent ID, without also loading the parent entity?

I have seen solutions that use projection to load the parent and zero or more children matching a condition.

Answer 1

If I understand you correctly, this should do it; it puts the conditions you want on both the parent and child, but selects only the child.

from parent in db.Parents
from child in parent.Children
where parent.Id = 4711 &&
      child.MyProperty == "olle"
select child;