python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions