Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I access the loop index inside a LINQ select?

Tags:

c#

linq

This code:

var customers = from cust in Customers
    group cust by new {cust.Country} into grouping
    select new
    {
        Country = grouping.Key.Country,
        Customers = grouping
    };

customers.ToList().ForEach(g => 
    Console.WriteLine("{0} has {1} customers: {2}", 
        g.Country, 
        g.Customers.Count(), 
        String.Join(", ",g.Customers.Select(x => "#. " + x.CompanyName).ToArray())
    ));

customers.Dump();

yields these results:

Argentina has 3 customers: #. Cactus Comidas para llevar, #. Océano Atlántico Ltda., #. Rancho grande
Austria has 2 customers: #. Ernst Handel, #. Piccolo und mehr
Belgium has 2 customers: #. Maison Dewey, #. Suprêmes délices
Brazil has 9 customers: #. Comércio Mineiro, #. Familia Arquibaldo, #. Gourmet Lanchonetes, #. Hanari Carnes, #. Que Delícia, #. Queen Cozinha, #. Ricardo Adocicados, #. Tradição Hipermercados, #. Wellington Importadora
Canada has 3 customers: #. Bottom-Dollar Markets, #. Laughing Bacchus Wine Cellars, #. Mère Paillarde
Denmark has 2 customers: #. Simons bistro, #. Vaffeljernet
...

How can I replace the "#" with an index/count so that I get results like these:

Argentina has 3 customers: 1. Cactus Comidas para llevar, 2. Océano Atlántico Ltda., 3. Rancho grande
...
like image 371
Edward Tanguay Avatar asked Nov 05 '09 16:11

Edward Tanguay


Video Answer


1 Answers

customers.ToList().ForEach(g => Console.WriteLine("{0} has {1} customers: {2}",
    g.Country, 
    g.Customers.Count(), 
    string.Join(", ",
        g.Customers.Select((x, i) => i + ". " + x.CompanyName).ToArray())));
like image 196
LukeH Avatar answered Sep 27 '22 23:09

LukeH