Question Select # records from each group in LINQ

[HLeyes]

I have a list of customers and invoices. The number of invoices per customer could be one or many. I am looking for a LINQ statement that would produce a list that would have only a specific number of records for each customer - let's say three per customer, whether the customer has one or a hundred. The original list will be sorted by customer number, then by invoice date descending. The goal is to produce a list of each customer with a maximum of three invoices (the most recent). Please see the attached screenshot.

Any help would be appreciated! Thanks.

HLeyes

 

[JohnH]

You will be using Enumerable.Take(IEnumerable<TSource>, Int32) Method (System.Linq) | Microsoft Docs
Example with a collection of items that has an ID:

var selection = from item in items
                group item by item.ID into g
                select g.Take(3);

 

[HLeyes]

JohnH - thank you for that! That's exactly what I needed. The capabilities of LINQ amaze me every day.

HLeyes