forum

Home / DeveloperSection / Forums / Use Multiple Column Group by in LINQ

Ask Question

Use Multiple Column Group by in LINQ

Norman Reedus 1782 25-Mar-2016
We want to use Multiple Column Group by in LINQ.How to use this please help me.
linq linq 
Updated on 25-Mar-2016
Norman Reedus

Norman Reedus

Follow

Can you answer this question?

Answer

1 Answers

Anonymous User

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

Liked By