title: Entity Framework 4 INNER JOIN help
body: <p>Can anyone tell me how to write the following query in Entity Framework 4.0? "Blogs" and "Categories" are my entities. The query basically returns me the list of categories and the number of blogs that are in that category.</p>
  
  <pre><code>SELECT b.CategoryId, c.Value, Count(b.Id) AS [Count] FROM dbo.Blogs b
  INNER JOIN dbo.Categories c ON b.CategoryId = c.Id
  GROUP BY b.CategoryId, c.Value
  </code></pre>
  
  <p>Thanks in advance.</p>