我有两个不同的对象列表,它们有几千个条目,但为了简单起见,我们假设它们如下所示:
LIST A [
{"001","James","London","Accountant"},
{"002","Laura","New York","Marketing"},
{"003","Zack","Austin","Support"},
{"004","Maggie","Phoenix","DevOps"}
]
LIST B [
{"002","09/10/2021"},
{"004","11/24/2009"}
]
因此,基本上我想使用一个LINQ查询,它将根据两个列表的ID(第一个条目)合并结果,形成如下所示的内容:
LIST RESULT [
{"002","Laura","New York","Marketing","09/10/2021"},
{"004","Maggie","Phoenix","DevOps","11/24/2009"}
]
到目前为止,我已经try 了几次,但最后一次没有给我预期的结果:
var Result = A.Where(p => B.All(p2 => p2.Id == p.Id)).ToList();