如何在Linq中的myTable WHERE id IN(SELECT ...)中写入SELECT? [英] How do I write SELECT FROM myTable WHERE id IN (SELECT...) in Linq?

问题描述

您如何在Linq中重写它?

How do you rewrite this in Linq?

SELECT Id, Name FROM TableA WHERE TableA.Id IN (SELECT xx from TableB INNER JOIN Table C....)

因此，以通俗的英语来说，我想从TableA中选择ID和名称，其中TableA的ID在第二个查询的结果集中.

So in plain english, I want to select Id and Name from TableA where TableA's Id is in a result set from a second query.

推荐答案

from a in TableA 
where (from b in TableB 
       join c in TableC on b.id equals c.id
       where .. select b.id)
.Contains(a.Id) 
select new { a.Id, a.Name }

这篇关于如何在Linq中的myTable WHERE id IN(SELECT ...)中写入SELECT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！