sql查询中要用到in 如果在linq to sql 中如何来实现呢,根据网上找到的方法如下:
var query = from a in db.crm_comment
join b in db.crm_user on a.shr equals b.account
where
(
from c in db.crm_detail
where c.customerid == id
select c.doc_id
).Contains(a.doc_id)
select new
{
doc_id = a.doc_id,
detail = a.detail,
status = a.status,
shr = a.shr,
shdate = a.shdate,
name = b.name
};