I have a pair of tables, with a 1-many relationship, and a FK defined. The model has navigational properties defined, child.parent and parent.children.
What works, against SQL Server, and doesn't seem to, in Effort:
var result = myDbContext.parents
.Where(p => p.name == "SMITH")
.Where(p => p.children.Any(c => c.age == 10)