LINQ:如何在多个字段上使用linq扩展方法样式进行JOIN? [英] LINQ: How to do JOIN using the linq extension method style on multiple fields?

问题描述

在下面的联接中，我想使用多个字段来进行联接，而不仅仅是一个字段.

In the Join below, I'd like to use multiple fields to do the join rather than just one field.

var join = group.Join(procSums, g => g.DeptID, ps => ps.key.deptID, (g, ps)...

我发现的所有示例都使用查询样式来执行此操作，而我无法翻译它.

All examples Ive found use the query style to do this and I can't translate it.

谢谢！

推荐答案

您只需要基于新的匿名对象进行加入:

You just have to Join based on new anonymous objects:

// ClasID is a placeholder, it could be any property you'd like
var join = group.Join(procSums,
                      g => new { g.DeptID, g.UnitLoc, g.Proc },
                      ps => new 
                            { 
                              DeptID = ps.key.deptID, 
                              UnitLoc = ps.key.unitLoc,
                              Proc = ps.key.procName 
                            },
                      (g, ps) => new { g, ps });

这篇关于LINQ:如何在多个字段上使用linq扩展方法样式进行JOIN?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！