title: Getting all months in an Year from Entity Framework core query
body: <p>I have done following <code>EF.core(3.1/3.2)</code> query</p>
  <pre><code>var monthlySalesList = context.Bids.Include(r =&gt; r.AllRequest).ThenInclude(r =&gt; r.Category).Where(b =&gt; b.UID== UID &amp;&amp; (b.Status == MyStatus.Awarded || b.Status == MyStatus.Completed))
                      .GroupBy(a =&gt; new { Month =a.InsertedDate.Month })
  
                    .Select(g =&gt; new MyServiceList()
                    {
                        Key = g.Key.ToString(),
                        Month = g.Key.Month.ToString(),
                        Total= g.Sum(s =&gt; s.totalBudget)
  
                    }).ToList();
  </code></pre>
  <p>I am not getting all months in an year instead it displays only 2 months say ( 10,11) with total.In above query Mystatus is an <code>ENUM</code> class and <code>MyserviceList Model</code> class contains get &amp; set such as <code>key,month,sum and total</code> .</p>
  <p>I am getting only</p>
  <pre><code>-----------------
  Months total
  ------------------
  10   1234
  11  1212
  </code></pre>
  <p>How can I get remaining months with zero value.</p>
  <pre><code>-----------------
  Months total
  ------------------
  1    0 
  2    0
  3    0
  4    0
  5    0
  6    0
  7    0
  8    0
  9    0
  10   1234
  11  1212
  12  0 
  </code></pre>