这个EF代码还原成sql是什么呀,新人求指教
mList = mList.Where(t => rrList.Where(r => ruList.Select(u => u.RoleID).Contains(r.RoleID)).Select(r => r.ModuleID).Contains(t.ID)).OrderBy(t => t.ModuleOrder).ToList()
select * from mlist t where t.RoleID in
(select RoleID from rrlist where RoleID in (select RoleID from ruList) u) r order by t.ModuleOrder
还原成sql这种问题不需要问
执行linq的同时,打开sql server management studio的tools下面的sql profiler,可以看到所有调用的sql