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 vote245 views4 answers
How to turn a string in a char list c#
C#
0 vote210 views1 answer
Selenum wait for element c#
C#
18 votes197 views3 answers
Add object to list c#
C#
0 vote228 views1 answer
Query mongodb collection as dynamic
C#
1 vote174 views1 answer
C# edit element in list
C#
4 votes171 views1 answer
C# open file dialog
C#
0 vote180 views1 answer
How to use open hardware monitor in c#
C#
0 vote185 views1 answer
Asp.net framework mvc cors error axios
C#
0 vote214 views1 answer
C# how to group console output into columns
C#
1 vote212 views1 answer
How to detect when a player move in unity
C#