linq查询的方法语法 [英] method syntax Of linq query

问题描述

我在linq中有一个查询，但我想要查询此查询的方法语法

i have a query in linq but i want into method syntax of this query

var q = (from account in Accounts
         join student in StudenTables
         on account.Alias equals student.stdID
         join cour in Course on student.stdID.Substring(2, 3) equals cour.CourseCode
         select new
         {
             account.Alias,
             cour.CName,
             student.stdName,
             student.stdFather,
             account.AccountId
         }).ToList();

所以如何转换此查询。有人告诉我。

so how can i convert this query. anyone tell me.

推荐答案

var query =
               Accounts.Join(StudenTables,
               a => new { a.Alias },
               s => new { Alias = s.stdID },
               (a, s) => new { a, s }).
               Join(Courses,
               x => new { CourseCode = x.s.stdID.Substring(2, 3) },
               c => new { c.CourseCode },
              (x, c) => new { x.a.Alias,
                              c.CName,
                              x.s.stdName,
                              x.s.stdFather,
                              x.a.AccountId }).ToList();

这篇关于linq查询的方法语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！