title: Include count = 0 in linq results
body: <p>I have a table having <code>TeamName</code> and <code>CurrentStatus</code> fields. I am making a linq query to get for each team and for each status the count of records:</p>
  
  <pre><code>var teamStatusCounts = models.GroupBy(x =&gt; new { x.CurrentStatus, x.TeamName })
                               .Select(g =&gt; new { g.Key, Count = g.Count() });
  </code></pre>
  
  <p>The results of this query returns all the counts except where count is 0. I need to get the rows where there is no record for a specific team and a specific status (where count = 0).</p>