读书人

看看解决办法

发布时间: 2013-10-21 17:02:52 作者: rapoo

看看
select MenuName from vm_sys_Menu where MenuID not in(73)
帮我把这条sql语句转成下面的这么linq
var result = (from a in dc.VM_SYS_Menu
where a.MenuID == id
select a).Single();

[解决办法]


var queryResult = (from a in dc.VM_SYS_Menu
where ! (new int?[] {73}).Contains(a.MenuID)
select a).Single();

[解决办法]
var result = (from a in dc.VM_SYS_Menu
where a.MenuID != 73
select a).Single();

[解决办法]
引用:
select MenuName from vm_sys_Menu where MenuID not in(73)
帮我把这条sql语句转成下面的这么linq
var result = (from a in dc.VM_SYS_Menu
where a.MenuID == id
select a).Single();

var query=dc.vm_sys_Menu.Where(a=>!new int[]{73}.Contains(a.MenuID))
.Select(a=>a.MenuName);

读书人网 >.NET

热点推荐