Linq到實(shí)體-SQL“in”子句在T-SQL中，可以有如下所示的查詢：SELECT * FROM Users WHERE User_Rights IN ("Admin", "User", "Limited")如何在LINQto實(shí)體查詢中復(fù)制？有可能嗎？
3 回答
波斯汪
TA貢獻(xiàn)1811條經(jīng)驗(yàn) 獲得超4個(gè)贊
查詢語法：
var selected = from u in users where new[] { "Admin", "User", "Limited" }.Contains(u.User_Rights)
select uforeach(user u in selected){
//Do your stuff on each selected user;}方法語法：
var selected = users.Where(u => new[] { "Admin", "User", "Limited" }.Contains(u.User_Rights));foreach(user u in selected){
//Do stuff on each selected user;}foreach(User u in users.Where(u => new [] { "Admin", "User", "Limited" }.Contains(u.User_Rights))){
//Do stuff on each selected user;}foreach(User u in users.FindAll(u => new [] { "Admin", "User", "Limited" }.Contains(u.User_Rights))){
//Do stuff on each selected user;}
ABOUTYOU
TA貢獻(xiàn)1812條經(jīng)驗(yàn) 獲得超5個(gè)贊
var desiredNames = new[] { "Pankaj", "Garg" }; var people = new[] {
new { FirstName="Pankaj", Surname="Garg" },
new { FirstName="Marc", Surname="Gravell" },
new { FirstName="Jeff", Surname="Atwood" } }; var records = (from p in people join filtered in desiredNames on p.FirstName equals filtered select p.FirstName).ToList();含有的缺點(diǎn)
List 1 List 2 1 12 2 7 3 8 4 98 5 9 6 10 7 6
- 3 回答
- 0 關(guān)注
- 488 瀏覽
添加回答
舉報(bào)
0/150
提交
取消