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?"

[Route("API/Use/GetUsageAlerts/{UserID}/{AccountID}")]
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
                               }).ToList();
    return userUsages;

 }


ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book