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

1 vote122 views1 answer
Loop through all enum values in C#
C#
1 vote167 views1 answer
Unity get direction from one point to another
C#Unity
0 vote129 views1 answer
Virtual list entity framework
C#
24 votes179 views2 answers
How to destroy an object in unity
C#Unity
0 vote135 views1 answer
Get directory name of path c#
C#
0 vote152 views1 answer
C# signalr console app client example
C#
0 vote170 views4 answers
How to turn a string in a char list c#
C#
0 vote132 views1 answer
How to split string into a list ignoring number of spaces c#
C#
0 vote141 views1 answer
How to get the date of the first day and last day of the week c#
C#
0 vote131 views1 answer
Select every second row in html table
C#