linq group by 后再in怎么写?

[BitNomad]

比如 select * from xxx where id in (select id from xxx group by xxx)

这样的怎么用linq写?

[kkun_3yue3]

http://www.cnblogs.com/lyj/archive/2008/01/25/1052713.html

[BitNomad]

那个文章我是看过的,这个sql不同是 有group by又有in 好像不支持

[yangqidong]

from p in Products where
(from c in Categories group c by c.CategoryID into g select g.Key).Contains(p.CategoryID)
select p