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