Add missing months to Linq result using Entity Framework in ASP.Net MVC

I will get back to you soon.

Use below code.

List<MyServiceList> monthlySalesList = context.Bids.Include(r => r.AllRequest).ThenInclude(r => r.Category).Where(b => b.UID == UID && (b.Status == MyStatus.Awarded || b.Status == MyStatus.Completed))
                                        .GroupBy(a => new { Month = a.InsertedDate.Month })
                                        .Select(g => new MyServiceList()
                                        {
                                            Key = g.Key.ToString(),
                                            Month = g.Key.Month.ToString(),
                                            Total = g.Sum(s => s.totalBudget)
                                        }).ToList();
List<string> months = new List<string>();
foreach (MyServiceList item in monthlySalesList.ToList())
{
    months.Add(item.Month);
}
for (int i = 0; i < 12; i++)
{
    MyServiceList sale = new MyServiceList();
    var isExist = months.Where(x => x.Equals(i.ToString())).ToList();
    if (isExist.Count == 0)
    {
        sale.Month = i.ToString();
        sale.Total = 0;
        monthlySalesList.Add(sale);
    }
}

dharmendr says:

Use below code.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

List<MyServiceList> monthlySalesList = context.Bids.Include(r => r.AllRequest).ThenInclude(r => r.Category).Where(b => b.UID == UID && (b.Status == MyStatus.Awarded || b.Status == MyStatus.Completed))                                         .GroupBy(a => new { Month = a.InsertedDate.Month })                                         .Select(g => new MyServiceList()                                         {                                             Key = g.Key.ToString(),                                             Month = g.Key.Month.ToString(),                                             Total = g.Sum(s => s.totalBudget)                                         }).ToList(); List<string> months = new List<string>(); foreach (MyServiceList item in monthlySalesList.ToList()) {     months.Add(item.Month); } for (int i = 0; i < 12; i++) {     MyServiceList sale = new MyServiceList();     var isExist = months.Where(x => x.Equals(i.ToString())).ToList();     if (isExist.Count == 0)     {         sale.Month = i.ToString();         sale.Total = 0;         monthlySalesList.Add(sale);     } }

 

 I already have done this in different way but is it possible everything in a single query by using enumerator.range()

No with single query not possible.