首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > .NET >

看看,该如何处理

2012-09-19 
看看select MenuName from vm_sys_Menu where MenuID not in(73)帮我把这条sql语句转成下面的这么linqvar

看看
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();


[解决办法]

C# code
var queryResult = (from a in dc.VM_SYS_Menuwhere ! (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();

热点排行