Finding parent records with children in LINQ

Question

I have a 1 to many foreign key related table and I am wondering how to create the following SQL Server query in a Entity Framework LINQ query to only find parent records that have child records?

SELECT p.ParentId ,p.ParentName FROM Parent p JOIN Child c on p.ParentId = c.ParentId GROUP BY p.ParentId, p.ParentName HAVING COUNT(c.ParentId) > 0

Please add a sample input and output data.

Rahul Singh
– Rahul Singh

2014-10-28 08:34:53 +00:00
Commented Oct 28, 2014 at 8:34 — Rahul Singh
– Rahul Singh, Commented Oct 28, 2014 at 8:34
Can you share your EF data-model?

Faris Zacina
– Faris Zacina

2014-10-28 08:52:40 +00:00
Commented Oct 28, 2014 at 8:52 — Faris Zacina
– Faris Zacina, Commented Oct 28, 2014 at 8:52

Maksim Satsikau · Accepted Answer · 2014-10-28 08:44:20Z

Inner join already limits your resultset to rows where both parent and child are present, so something like below should work:

var parentsWithChildren = ( from parent in Parent	join child in Child on parent.ParentId equals child.ParentId	select new { parent.ParentId, parent.ParentName } ).Distinct();

Collectives™ on Stack Overflow

Finding parent records with children in LINQ

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related