Geek asks and answers

A group for a key-value pair, where the value is a list of items that use the same key

How to create a “complex” object from a list of fields

eg:.

public class Lines {
  public string itemName;
  public string locationName;
  public string locationGeo;

}

List<Lines> lines = new List<Lines>(){
    new Lines() {itemName= "item1", locationName="someloc1", locationGeo="1.11, 1.11"},
    new Lines() {itemName= "item1", locationName="someloc2", locationGeo="1.12, 1.12"},
    new Lines() {itemName= "item1", locationName="someloc3", locationGeo="1.13, 1.13"},
    new Lines() {itemName= "item2", locationName="someloc4", locationGeo="1.14, 1.14"},
    new Lines() {itemName= "item2", locationName="someloc5", locationGeo="1.15, 1.15"}
}

Group something like an example:

public class exampleLines{
    public string itemName;
    public locations locs;
}

ps: this class does not exist at all.

+3
source share
1 answer

So you want to group by itemName? Sort of:

var query = lines.GroupBy(x => x.itemName)
      .Select(g => new { ItemName = g.Key,
                         Locations = g.Select(x => new { Name = x.locationName,
                                                         Geo = x.locationGeo })
                                      .ToList() })
      .ToList();

This led to two anonymous types: once for the container class and once for the location part.

+9
source

More articles:


All Articles