sql中的in 在linq中如何运用
var zhibiao2 =context.ExecuteQuery<Zhibiao>("select * from Zhibiao where ChileBase='"+childBaseCode+
  "' or Code in (select Code from ChildbaseRzhibiao where childBaseCode='"+childBaseCode+"')");
如何将上面的sql语句转换成linq语句？

------解决方案--------------------
var tmpResult = from z in Zhibiao join c in ChildbaseRzhibiao
on z.Code Equls c.Code
where c.ChileBase.Equls(childBaseCode)