Use Multiple Column Group by in LINQ

Norman Reedus 2218 25 Mar 2016

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

Norman Reedus

Other

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

Can you answer this question?

1 Answers