LAMBDA C# union informations

Question

Using C# with Lambda(or some method), how can I merge different informations(from columns) of the same intituition name ? They can have some common and some different fields.

See a example below:

your sample data isn't enough to get a clear picture of what you want exactly — Jonesopolis, Jan 19 '17 at 16:38

score 0 · Accepted Answer · edited May 23 '17 at 11:52

0

Have you tried the Group By instruction ?

Here is an other stackoverflow about this : Group by in LINQ

edited May 23 '17 at 11:52

Community

1
1

answered Jan 19 '17 at 16:46

Bagriel

54
6

3

This is a comment, not an answer – bolt19 Jan 19 '17 at 16:49

score 0 · Answer 2 · answered Jan 19 '17 at 18:16

    {
        List<Instituition> Instituitions = new List<Instituition>() { 
        new Instituition { Name = "Name1", Alias = "",Area="" },
        new Instituition { Name = "Name1", Alias = "Alias1",Area="" },
        new Instituition    { Name = "name2", Alias = "Audi" ,Area="444"},
         new Instituition { Name = "Name1", Alias = "",Area="Garden" }};


        var results = Instituitions.GroupBy(i =>  i.Name,
                           i => i.Alias,
                           (key, g) => new
                           {
                               Name = key,
                               Alias = g.Where(a =>a != "").FirstOrDefault(),
                               Area = Instituitions.Where(a=>a.Name == key && a.Area != "").Select(a=>a.Area).FirstOrDefault()
                           }                             

                          );


    }

    class Instituition
    {
        internal string Name;
        internal string Alias;
        internal string Area;
    }

LAMBDA C# union informations

2 Answers2