Entity Framework 6 - Select Parents Where Children Equal

Question

I just need Parent objects. In SQL, this is simple:

select distinct * from parent join child on child.ParentID = Parent.ID where child.playssoccer = true;

In Entity Framework 6, this seems like splitting the atom to me.

I need new p => parent where parents.children.playssoccer = true .

How do I get soccer parents out of a similar EF6 DBContext?

Thanks, everybody! Paul Abbott's answer worked for me, so I'm giving him the checkmark. Everybody gets upvote, tho. I appreciate the timely responses. — John Dunagan
– John Dunagan, Commented May 9, 2014 at 18:27
Actually your question isn't about EF , it's about Linq usage: ) — stackunderflow
– stackunderflow, Commented May 9, 2014 at 19:17

Paul Abbott · Accepted Answer · 2014-05-09 18:13:14Z

from p in context.Parents where p.Children.Any(c => c.PlaySoccer == true) select p

This is assuming you want parents who have at least one child that plays soccer.

Dean · Accepted Answer · 2014-05-09 18:45:46Z

3

If you have navigation properties you can do something like

Parents.Where(p => p.child.playsoccer)

12.2k8 gold badges57 silver badges113 bronze badges

answered May 9, 2014 at 18:12

1712 silver badges19 bronze badges

Comments

T McKeown · Accepted Answer · 2014-05-09 18:14:48Z

2

Parents .Where(p=> p.child.playsoccer) .GroupBy(p=> p.Parent.ID)

answered May 9, 2014 at 18:14

12.9k1 gold badge27 silver badges35 bronze badges