如何使用LAMBDA表达式在LINQ中进行IN或CONTAINS处理? [英] How do you do an IN or CONTAINS in LINQ using LAMBDA expressions?

问题描述

我有以下Transact-Sql，我正尝试将其转换为LINQ ...并正在挣扎.

I have the following Transact-Sql that I am trying to convert to LINQ ... and struggling.

SELECT * FROM Project
WHERE Project.ProjectId IN (SELECT ProjectId FROM ProjectMember Where MemberId = 'a45bd16d-9be0-421b-b5bf-143d334c8155')

任何帮助将不胜感激……如果可能的话，我想使用Lambda表达式来做.

Any help would be greatly appreciated ... I would like to do it with Lambda expressions, if possible.

提前谢谢！

推荐答案

GFrizzle击败了我.但是这是C#版本

GFrizzle beat me to it. But here is a C# version

var projectsMemberWorkedOn = from p in Projects
                    join projectMember in ProjectMembers on
                        p.ProjectId equals projectMember.ProjectId
                    where projectMember.MemberId == "a45bd16d-9be0-421b-b5bf-143d334c8155"
                    select p;

还有一个纯LINQ方法链版本:

And as a bonus a purely LINQ method chain version as well:

var projectsMemberWorkedOn =
            Projects.Join( ProjectMembers, p => p.ProjectId, projectMember => projectMember.ProjectId,
                ( p, projectMember ) => new { p, projectMember } )
                .Where( @t => @t.projectMember.MemberId == "a45bd16d-9be0-421b-b5bf-143d334c8155" )
                .Select(@t => @t.p );

这篇关于如何使用LAMBDA表达式在LINQ中进行IN或CONTAINS处理?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！