请问该如何用LINQ的lambda表达式写出Select语句中的NOT IN 语句？

Question

如何用LINQ的lambda表达式写出Select语句中的NOT IN

Answer 1

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);}

Answer 2

使用 LINQ 查询表达式IEnumerable<SelectListItem> stores =from store in database.Storeswhere store.CompanyID == curCompany.IDselect 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;