我在該串列中有一個串列,還有一個串列。如何檢查id是否存在于任一串列中。
public class Users
{
public virtual Userid { get; set; }
public virtual List<UserCity> UserCities { get; set; }
}
和
public class UserCity
{
public virtual UserCityId { get; set; }
public virtual UserCityName { get; set; }
}
如何獲得users其中的內容Userid =usercityid。
我試過這樣的Linq查詢
List<Users> lstusers = new List<Users>();
lstusers = lstusers
.Where(x=>x.UserCity.Any(w => w.UserCityId == w.Userid ))
.ToList();
如果用戶有usercityid相同的userid我需要得到那些users。
uj5u.com熱心網友回復:
您的查詢中有一些錯誤。嘗試這個:
// create a dummy list for testing
var lstusers = new List<Users>
{
new Users {Userid = 1, UserCities = new List<UserCity>{ new UserCity { UserCityId = 1, UserCityName="xxx"} } }
};
// execute the linq-query
lstusers = lstusers.Where(x => x.UserCities.Any(w => w.UserCityId == x.Userid)).ToList();
// and print the number of users found
Console.WriteLine($"Number of users found: {lstusers.Count}");
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/428914.html
