페이지

2022년 9월 12일 월요일

C# LINQ Group by Count

 

Car[] cars = new[]
{
new Car(1, "one"), new Car(2, "two"), new Car(3, "three"), new Car(4, "four"), new Car(5, "five"), new Car(6, "six")
, new Car(3, "three 2"), new Car(4, "four"), new Car(5, "five")
, new Car(3, "three"), new Car(4, "four")
, new Car(3, "three 2")
};

var q = from a in cars group a by new
{
a.id, a.name
} into g
select (g.Key.id , g.Key.name, count: g.Count()) ;
foreach (var a in q)
{
if (a.count >= 2)
{
Console.WriteLine(a);
}

}

output

(3, three, 2)
(4, four, 3)
(5, five, 2)
(3, three 2, 2)