Groupby in linq

        //Method Syntax

        List<Result> results2 = persons
            .GroupBy(p => p.PersonId, 
                     (k, c) => new Result()
                             {
                                 PersonId = k,
                                 Cars = c.Select(cs => cs.car).ToList()
                             }
                    ).ToList();

Source: stackoverflow.com

Groupby in linq

var results = from p in persons
              group p.car by p.PersonId into g
              select new { PersonId = g.Key, Cars = g.ToList() };

Source: stackoverflow.com

Linq group by

var results = persons.GroupBy(
    p => p.PersonId, 
    p => p.car,
    (key, g) => new { PersonId = key, Cars = g.ToList() });

Source: stackoverflow.com

Group-by-in-linq

using System;using System.Linq;using System.Collections.Generic;class Person{   public int PersonId;   public string car ; }class Result{  public int PersonId;  public List<string> Cars; }public class Program{  public static void Main()  {    List<Person> persons = new List<Person>()    {      new Person { PersonId = 1, car = "Ferrari" },      new Person { PersonId = 1, car = "BMW" },      new Person { PersonId = 2, car = "Audi"}    };    //With Query Syntax    List<Result> results1 = (      from p in persons      group p by p.PersonId into g      select new Result()        {          PersonId = g.Key,           Cars = g.Select(c => c.car).ToList()        }      ).ToList();    foreach (Result item in results1)    {      Console.WriteLine(item.PersonId);      foreach(string car in item.Cars)      {        Console.WriteLine(car);      }    }    Console.WriteLine("-----------");            //Method Syntax

        List<Result> results2 = persons
            .GroupBy(p => p.PersonId, 
                     (k, c) => new Result()
                             {
                                 PersonId = k,
                                 Cars = c.Select(cs => cs.car).ToList()
                             }
                    ).ToList();

        foreach (Result item in results2)    {      Console.WriteLine(item.PersonId);      foreach(string car in item.Cars)      {        Console.WriteLine(car);      }    }  }}

Source: stackoverflow.com

Similar codes

0 vote343 views1 answer
C# linq aggregate string builder
C#
1 vote369 views1 answer
How to pause code execution in c#
C#
0 vote373 views1 answer
C# get display resolution
C#
0 vote337 views1 answer
C# run file
C#
1 vote362 views2 answers
Windows form textbox numbers only
C#
30 votes422 views3 answers
How to create a list in c# unity
C#Unity
1 vote350 views2 answers
Unity change material at runtime
C#
0 vote329 views1 answer
Pyautogui not odwnloading
C#
0 vote339 views1 answer
C# override gethashcode
C#
0 vote336 views1 answer
C-sharp - get current page url/path/host
C#