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 vote129 views1 answer
C# find all indexes
C#
0 vote93 views1 answer
Canceltion token c#
C#
0 vote134 views2 answers
Install active directory windows server 2019 powershell
C#
47 votes136 views5 answers
Remove last character from string c#
C#
0 vote130 views1 answer
Devexpress aspxdatagridview set VerticalScrollableHeight in codebehind
C#
3 votes135 views2 answers
If string contains number c#
C#
0 vote126 views4 answers
Switch statement c# example
C#
0 vote131 views1 answer
Function on program stops unity
C#
0 vote132 views1 answer
Displayname c#
C#
0 vote140 views1 answer
Get all properties of an object including children c#
C#