forum

home / developersection / forums / use multiple column group by in linq

Ask Question

Use Multiple Column Group by in LINQ

Norman Reedus 2176 25-Mar-2016

We want to use Multiple Column Group by in LINQ.How to use this please help me.

linq

Updated on 25-Mar-2016

Norman Reedus

Other

Message

Can you answer this question?

Answer

1 Answers

Anonymous User

25-Mar-2016

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace ForumMVC.Controllers{
    public class HomeController : Controller
    {
        forumEntities context = new forumEntities();
        public ActionResult Index()
        {
            var result = from c in context.CUSTOMER.ToList()
                         group c by new
                         {
                             c.CUST_NAME,
                             c.CUST_ADDRESS,
                             c.CUST_PHONE,
                         } into gcs
                         select new CUSTOMER()
                         {
                             CUST_NAME = gcs.Key.CUST_NAME,
                             CUST_ADDRESS = gcs.Key.CUST_ADDRESS,
                             CUST_PHONE = gcs.Key.CUST_PHONE,
                         };
            return View();
        }
    }
}

forum

Use Multiple Column Group by in LINQ

Norman Reedus

Can you answer this question?

1 Answers

Liked By