如何用LINQ的lambda表達(dá)式寫(xiě)出Select語(yǔ)句中的NOT IN
2 回答
慕俠2389804
TA貢獻(xiàn)1719條經(jīng)驗(yàn) 獲得超6個(gè)贊
List<int> myint = new List<int>();
myint.Add(3);
myint.Add(4);
myint.Add(5);
myint.Add(6);
List<int> myint2 = new List<int>();
myint2.Add(3);
myint2.Add(4);
var resint = myint.Except(myint2);
foreach (int item in resint)
{
Console.Write(item);
}
縹緲止盈
TA貢獻(xiàn)2041條經(jīng)驗(yàn) 獲得超4個(gè)贊
使用 LINQ 查詢表達(dá)式
IEnumerable<SelectListItem> stores =
from store in database.Stores
where store.CompanyID == curCompany.ID
select new SelectListItem { Value = store.Name, Text = store.ID };
ViewBag.storeSelector = stores;
或使用 LINQ 擴(kuò)展方法和 lambda 表達(dá)式
IEnumerable<SelectListItem> stores = database.Stores
.Where(store => store.CompanyID == curCompany.ID)
.Select(store => new SelectListItem { Value = store.Name, Text = store.ID });
ViewBag.storeSelector = stores;
添加回答
舉報(bào)
0/150
提交
取消