group by multiple columns in linq to sql c#

group by multiple columns in linq to sql c#

This is basically used for "How to Group By multiple columns in LINQ to SQL?"

public IEnumerable<UsageAlerts> GetUsageAlerts(int UserID, int AccountID)
      DALUse ObjDalUse = new DALUse();
      Mapper mapper = new Mapper();
      List<UsageAlerts> usedAlerts = mapper.MapDALUsageAlerts2BAL(ObjDalUse.getAllUsageAlerts(UserID, AccountID));

     List<UsageAlerts> userUsages = (from used in usedAlerts
                              group used by used.ProductServiceId into res
                              select new UsageAlerts
                                 UsageIncluded = res.Sum(l => l.UsageIncluded),
                                 UsedUnit = Convert.ToString(res.Sum(m => int.Parse(m.UsedUnit))),
                                 Product = Convert.ToString(res.Max(l => l.Product)),
                                 ProductServiceId = res.Key
    return userUsages;



Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog -
My Books - Book 1 and Book 2 Powered by Blogger.