看看解决办法

2013-10-21

看看select MenuName from vm_sys_Menu where MenuID not in(73)帮我把这条sql语句转成下面的这么linq var

看看
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

看看解决办法