Ef框架使用 in 方法

var query=db.UserDetailss.where(u=>true);
var queryList=from u in query
where (from u in db.Users select u.id).Contains(u.UserId)
select u;

查询出来的语句为

select * from userdetailss where userid in (select id from users)

中间可以插入条件

如

where (from u in db.Users where u.name.Contains("123") select u.id)

查询出来的语句为

select * from userdetailss where userid in (select id from users where name like '%123%')

也可以not in  加个！即可

如

where !(from u in db.Users where u.name.Contains("123") select u.id)