如何用LINQ的lambda表達式寫出Select語句中的NOT IN
2 回答
慕俠2389804
TA貢獻1719條經驗 獲得超6個贊
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貢獻2041條經驗 獲得超4個贊
使用 LINQ 查詢表達式
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 擴展方法和 lambda 表達式
IEnumerable<SelectListItem> stores = database.Stores
.Where(store => store.CompanyID == curCompany.ID)
.Select(store => new SelectListItem { Value = store.Name, Text = store.ID });
ViewBag.storeSelector = stores;
添加回答
舉報
0/150
提交
取消