读书人

linq 如何实现 in

发布时间: 2011-12-17 23:37:33 作者: rapoo

linq 怎么实现 in
请问将下面的sql语句,转换成linq 怎么写?
SELECT * FROM tableA WHERE idfiled IN
(select top 10 idfiled from tableB group by idfiled order by count(*) DESC)

[解决办法]
可以用contains
[解决办法]
http://chenjianyi007.blog.163.com/blog/static/10020320520109802355766/
[解决办法]

C# code
from c in db.tableAs where (from t in db.tableBs select t.idfiled).Take(10).ToList().Contains(c.idfiled)select c;
[解决办法]
探讨
请问将下面的sql语句,转换成linq 怎么写?
SELECT * FROM tableA WHERE idfiled IN
(select top 10 idfiled from tableB group by idfiled order by count(*) DESC)

[解决办法]
探讨
请问将下面的sql语句,转换成linq 怎么写?
SELECT * FROM tableA WHERE idfiled IN
(select top 10 idfiled from tableB group by idfiled order by count(*) DESC)

[解决办法]
http://blog.csdn.net/q107770540/article/details/5387946

读书人网 >.NET

热点推荐