Merge two lists objects

Question

i'm having a problem with merging two list of object here they are:

first one
List<NSKData> NSKDataList = new List<NSKData>();

public class NSKData
{
    public string ID { get; set; }
    public string Issue { get; set; }
    public string ToolTipInfoText { get; set; }
    public NSKData() { }
    public NSKData(string id, string issue, string tooltipinfo)
    {
        ID = id;
        Issue= issue;
        ToolTipInfoText = tooltipinfo;
    }
}

 second one
 List<IssuesMoreInfo> IssuesMoreInfoList = new List<IssuesMoreInfo>();

public class IssuesMoreInfo
{
    public string ID { get; set; }
    public string IssueMoreInfoText { get; set; }
}

If i can get all needed data at one time, i wont ask this question, but i'm grabbing all data for fist one, and only after i can get data for second one.

So, what i need in result is: to get IssueMoreInfo from second one, according to ID in both, like for id 10 in first one, we getting IssueMoreInfoText column in second one and pass it to firt one list in column ToolTipInfoText

Hope for your help, guys, thanks

Answer 1

I assume you're looking for Enumerable.Join:

var query = from data in NSKDataList 
            join info in IssuesMoreInfoList 
            on data.ID equals info.ID
            select new NSKData(data.ID, data.Issue, info.IssueMoreInfoText);
NSKDataList = query.ToList();

Another way which does not need to re-create all objects and the list:

var infoIdLookup = IssuesMoreInfoList.ToLookup(i => i.ID);
foreach(NSKData data in NSKDataList)
{
    data.ToolTipInfoText = infoIdLookup[data.ID]
       .Select(i => i.IssueMoreInfoText)
       .FirstOrDefault();
}

Answer 2

Try using Linq Join

var query = from c in NSKDataList 
            join o in IssuesMoreInfoList on c.ID equals o.ID
            select new { c.ID, c.Issues , c.ToolTipInfoText , o.IssueMoreInfo  };

The query will contains info from both of the lists

http://www.dotnetperls.com/join