¡@

Home 

c# Programming Glossary: p.parentid

LINQ - Left Join, Group By, and Count

http://stackoverflow.com/questions/695506/linq-left-join-group-by-and-count

Join Group By and Count Let's say I have this SQL SELECT p.ParentId COUNT c.ChildId FROM ParentTable p LEFT OUTER JOIN ChildTable.. FROM ParentTable p LEFT OUTER JOIN ChildTable c ON p.ParentId c.ChildParentId GROUP BY p.ParentId How can I translate this.. JOIN ChildTable c ON p.ParentId c.ChildParentId GROUP BY p.ParentId How can I translate this into LINQ to SQL I got stuck at the..