如何使用方法语法在linq中连接到sql? [英] How to do a join in linq to sql with method syntax?

问题描述

我已经在LINQ to SQL示例中看到了很多有关如何进行查询语法联接的示例，但是我想知道如何使用方法语法进行联接吗?例如，我该怎么做

I have seen lots of examples in LINQ to SQL examples on how to do a join in query syntax but I am wondering how to do it with method syntax? For example how might I do the following

var result = from sc in enumerableOfSomeClass
             join soc in enumerableOfSomeOtherClass
             on sc.Property1 equals soc.Property2
             select new { SomeClass = sc, SomeOtherClass = soc }

带有.Join()?谁能说明或提供另一个简单的例子?

with a .Join()? Can anyone illustrate or provide another simple example?

推荐答案

var result = from sc in enumerableOfSomeClass
             join soc in enumerableOfSomeOtherClass
             on sc.Property1 equals soc.Property2
             select new { SomeClass = sc, SomeOtherClass = soc };

相当于:

var result = enumerableOfSomeClass
    .Join(enumerableOfSomeOtherClass,
          sc => sc.Property1,
          soc => soc.Property2,
          (sc, soc) => new
                       {
                           SomeClass = sc,
                           SomeOtherClass = soc
                       });

如您所见，在进行连接时，查询语法通常比lambda语法更具可读性.

As you can see, when it comes to joins, query syntax is usually much more readable than lambda syntax.

这篇关于如何使用方法语法在linq中连接到sql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！