group by multiple columns in linq to sql c#

group by multiple columns in linq to sql

Today's I have a requirement to group multiple columns in linq to sql which are given below.

The below UserUsage table have AParty_Subscriber, ProductService, NetworkID and Unit columns.

I am going to filter UserUsage table using group by multiple columns. i.e.

List<UserUsage> userUsages = (from a in use
                                            group a by new {
                                into b select new UserUsage {
                                              AParty_Subscriber = b.Key.AParty_Subscriber,
                                              ProductService = b.Max(a => a.ProductService),
                                              NetworkID = b.Max(a => a.NetworkID),
                                              Unit = b.Sum(a => int.Parse(a.Unit)).ToString()



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 - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions