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.csdn.net/zhangyumei/article/details/5620363