LinQ to SQL实现 SQL in

  简单的in

List<int> list

from o in table where list.Contain(o.id)select o

in 中还包含一层查询的：

from h in context.hTtest
  where(from o in context.oTest
  where o.IID==id
  select o.ID).Contains(h.OID)
  select h
                                                    

参考资料：http://blog.youkuaiyun.com/zhangyumei/article/details/5620363