这条SQL语句用Linq怎么写，谢谢！

ntntyy 发布于 2011-10-29 10:31， 738 次点击

select modeName from sys where id in (select sysid from quanXianBiao where quanxianmingchengID in (select qxid from users where id=1))

三个表嵌套查询，如何转化成linq查询

1 回复

long896613142012-01-16 09:41

string sql = "select modeName  from  sys where id in (select sysid from quanXianBiao where quanxianmingchengID in (select qxid from users where id=1))";
               string[] arr = { };
               return db.ExecuteQuery<ResumeInfo>(sql, arr).ToList();