Use Multiple Column Group by in LINQ

Norman Reedus 2312 25 Mar 2016

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

Ask by Norman Reedus

Updated 25 Mar 2016

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();
        }
    }
}

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Use Multiple Column Group by in LINQ

Can you answer this question?

1 Answers