c# - 在指定列上连接两个列表

Question

我正在尝试在 ID 列上连接两个列表(flist 和 slist)。下面显示列表定义、类定义、列表内容和所需结果。

List<first> flist= new List<first>();
List<second> slist= new List<second>();


public class first
{
   public string name { get; set; }
   public int ID{ get; set; }
   public string itemAttr { get; set; }
}
public class second
{
   public int ID{ get; set; }
   public string itemAttr{ get; set; }
}

列表内容

flist:
apples | 1
bananas| 2
trees  | 3

slist:
1      | fruit
3      | not-fruit

期望的结果:

flist:
apples   |   1     | fruit
bananas  |   2     |
trees    |   3     | not-fruit

Answer 1

List<first> flist= new List<first>();
List<second> slist= new List<second>();

var result = from f in flist
             join s in slist on f.ID equals s.ID into g
             select new {
                 f.name,
                 f.ID,
                 itemAttr = g.Any() ? g.First().itemAttr : null
             };