如何使用“在”实体框架中的SQL关键字？ [英] How to use 'In' SQL keyword in Entity Framework?

问题描述

这是我的SQL命令

SELECT KEY,NAME
from  COMPANY c 
WHERE     KEY IN (select KEY from USER_COMPANY  where UserId = @UserId)
order by NAME asc

所以我想将其转换为实体框架。

So I want to convert it to Entity Framework.

我试着像这样

 var userCompany = (from u in db.USER_COMPANY
                         where u.UserId == UserId 
                         select(u.KEY));

            var user = (from c in db.COMPANY
                        where (c => userCompany.Contains(c.KEY)
                        select c);

但它不工作。

如何使用SQL 在关键字在实体框架？

How to use the SQL IN keyword in Entity Framework?

推荐答案

试试这个：

var query = from c in db.COMPANY
            where (from u in db.USER_COMPANY
                   where u.UserId == UserId
                   select u.KEY).Contains(c.KEY)
            orderby c.NAME
            select c.KEY, c.NAME;

这篇关于如何使用“在”实体框架中的SQL关键字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！