谁能帮我把这个sql语句改成linq的

[linger_liang]

select * from SysUserTbl
where ID in (select UserID from SysUserGroupGrantTbl where UserGroupID in (select UserGroupID from SysUserGroupGrantTbl where UserID = 83))

就是上面这个sql语句改成勇linq实现的，谢谢了

[luotitan]

string sql = "select * from SysUserTbl where ID in (select UserID from SysUserGroupGrantTbl where UserGroupID in (select UserGroupID from SysUserGroupGrantTbl where UserID =83))";
var query = db.ExecuteQuery<SysUserTbl>(sql);
foreach (var e in query)
{
string ss = ss + e.ID.ToString() ;
}

[leehniu]

复杂是sql语句，可以用视图，然后再用linq

[rafer]

dim db as new datacontext
dim temp1 =from o in db.SysUserGroupGrantTbl where o.UserID=83 select o.UserGroupID
dim temp2 =from o in db.SysUserGroupGrantTbl where temp1.contains(o.UserGroupID) select o.UserID
dim result=from o in db.SysUserTbl where temp2.contains(o.id) select o

未调试，不知道是否正确，请大家多多指教！

[lbaeolus]

from p in db.SysUserGrouGrantTbl.Where(d=>d.UserID = 83)
join q in db.SysUserGroupGranTbl
on p.UserGroupID equals q.UserGroupID
join o in SysUserTbl
on o.ID equals p.UserID
Select o

[sun363]

学习了……

[longyishuaige]

不懂 呵呵 路过

[fyqwork]

路过，帮顶！

[LemIST]

from su in sysusertbl
join sugg in SysUserGroupGrantTbl
on su.ID equals sugg.userid
join sugg2 in SysUserGroupGrantTbl
on sugg.usergroupid equals sugg2.usergroupid
where sugg2.userid == 83
select su

[LRG315]

用Contains可以实现:

var query =
from S in Context.SysUserTbl
where (from S1 in Context.SysUserGroupGrantTbl
where (from S2 in Context.SysUserGroupGrantTbl
where UserID = 83
select S2.UserGroupID
).Contains(S1.UserGroupID)
select S1.UserID
).Contains(S.ID)
select S;

[悔说话的哑巴]

linq还在 看书

[goshine]

这么复杂.看得都头疼了

[Adechen]

没有测试，也许有误

var sysuser=from su in SysUserTbl
join sugg in SysUserGroupGrantTbl on su.ID equals sugg.UserID
join sug in SysUserGroupGrantTbl on sugg.UserGroupID euals sug.UserGroupID
where sug.UserID=83
select su

[i670064012]

学习，当中

[qq18527575]

from sysUserTbl jion from SysUserGroupGrantTbl.id equals sysUserTbl.id
where sysUserTbl.UserGroupID jion SysUserGroupGrantTbl.UserGroupID equals SysUserGroupGrantTbl .UserID = 83

[randomfeel]

linq 学ing...

[qawszx]

[Quote=引用 13 楼 lemist 的回复:]
from su in sysusertbl
join sugg in SysUserGroupGrantTbl
on su.ID equals sugg.userid
join sugg2 in SysUserGroupGrantTbl
on sugg.usergroupid equals sugg2.usergroupid
where sugg2.userid == 83
select su
[/Quote]

试试吧

[maomao90]

学习，帮顶

[meible2008]

大哥你这个题目是忽悠人的吧

[丰云]

搂主的确在忽悠人！
鉴定毕！

另附：
var tmpResult = DataContent.SysUserTbl.SingleOrDefault(p => p.DEST_ID == 83);

[丰云]

改正：
var tmpResult = DataContent.SysUserTbl.SingleOrDefault(p => p.ID == 83);

呵呵