Converting a LINQ query into a Dictionary<string, string[]>

Question

I've got a query that returns something of the following format:

{ "tesla", "model s" }
{ "tesla", "roadster" }
{ "honda", "civic" }
{ "honda", "accord" }

and I'd like to convert that to a dictionary of <string, string[]> like so:

{ "tesla" : ["model s", "roadster"],  "honda" : ["civic", "accord"] }

I've tried with this:

var result = query.Select(q => new { q.Manufacturer, q.Car}).Distinct().ToDictionary(q => q.Manufacturer.ToString(), q => q.Car.ToArray());

but so far I am not having any luck. I think what this is doing is actually trying to add individual items like "tesla" : ["model s"] and "tesla" : ["roadster"] and that's why it's failing ... any easy way to accomplish what I am trying to do in LINQ?

Possible duplicate of stackoverflow.com/questions/7325278/group-by-in-linq? — feralin
– feralin, Commented Jul 3, 2013 at 18:44

p.s.w.g · Accepted Answer · 2013-07-03 18:44:46Z

3

You would need to group each item by the key first, then construct the dictionary:

result = query.Select(q => new { q.Manufacturer, q.Car}).Distinct()
              .GroupBy(q => q.Manufacturer)
              .ToDictionary(g => g.Key, 
                            g => g.Select(q => q.Car).ToArray());

Of course, an ILookup<string, string> much easier:

result = query.Select(q => new { q.Manufacturer, q.Car }).Distinct()
              .ToLookup(q => q.Manufacturer, q => q.Car);

answered Jul 3, 2013 at 18:44

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user7116 · Accepted Answer · 2013-07-03 18:45:49Z

3

You're looking for ToLookup if you would like the results to be grouped into a dictionary-like object:

var result = query.Select(q => new { q.Manufacturer, q.Car})
                  .Distinct()
                  .ToLookup(q => q.Manufacturer.ToString(), q => q.Car);

Otherwise you will have to group the results first:

var result = query.Select(q => new { q.Manufacturer, q.Car })
                  .Distinct()
                  .GroupBy(q => q.Manufacturer)
                  .ToDictionary(gg => gg.Key,
                                gg => gg.Select(q => q.Car).ToArray());

answered Jul 3, 2013 at 18:45

user7116

64.3k17 gold badges150 silver badges175 bronze badges

Comments

rossipedia · Accepted Answer · 2013-07-03 18:43:49Z

1

What you want is GroupBy(), followed by ToDictionary().

Example:

var result = query.GroupBy(q => q.Manufacturer).ToDictionary(q => q.Key, q => q.Value.ToArray());

What GroupBy() does is group all the elements that have the same matching key selector. So when you tell it to GroupBy(q => q.Manufacturer), all the elements that have the same Manufacturer will be grouped together as IEnumerable<T>.

answered Jul 3, 2013 at 18:43

rossipedia

59.8k10 gold badges95 silver badges94 bronze badges

Comments

sehe · Accepted Answer · 2013-07-03 18:44:10Z

0

Use ToLookup:

var table = pairs.ToLookup(kvp => kvp.Key, kvp => kvp.Value);

foreach(var i in table["tesla"])
   Console.WriteLine(i);

answered Jul 3, 2013 at 18:44

sehe

400k49 gold badges475 silver badges673 bronze badges

Collectives™ on Stack Overflow

Converting a LINQ query into a Dictionary<string, string[]>

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related