Group Multiple Tables in LINQ <p>I have a very simple SQL query </p> <pre><code>Select r.SpaceID,Count(*), SpaceCode from Rider r join Spaces s on r.SpaceID=s.SpaceID Group By r.SpaceID, s.SpaceCode </code></pre> <p>Please note that my group by clause is on multiple tables, i want to do the same in linq, i know how to group single table, but about multiple tables i have no idea.</p>