I have two lists and I need to compare them and only return a List of Items not in both.
我有两个列表,我需要对它们进行比较,并且只返回两个列表中没有的项的列表。
var listOfIds = new List<int> {1,2,4};
var persons = new ObservableCollection<Person>
{
new Person {Id = 1, Name = "Person 1"},
new Person {Id = 2, Name = "Person 2"},
new Person {Id = 3, Name = "Person 3"},
new Person {Id = 4, Name = "Person 4"}
};
In this example new Person {Id = 3, Name = "Person 3"}
would be the result. A Linq solution would be preferred.
在这个示例中,新Person {Id = 3,结果是Name = "Person 3"}。最好使用Linq解决方案。
2 个解决方案
#1
38
not in will work for you
不进来会对你有用的
var listOfIds = new List<int> {1,2,4};
var query = from item in persons
where !listOfIds .Contains( item.id )
select item;
You can check for more detail : SQL to LINQ ( Case 7 - Filter data by using IN and NOT IN clause)
您可以检查更多细节:SQL到LINQ(案例7 -使用IN和NOT IN子句过滤数据)
#2
29
You can also use lambda:
你也可以用lambda:
var query = persons.Where(item => !listOfIds.Contains(item.Id));
#1
38
not in will work for you
不进来会对你有用的
var listOfIds = new List<int> {1,2,4};
var query = from item in persons
where !listOfIds .Contains( item.id )
select item;
You can check for more detail : SQL to LINQ ( Case 7 - Filter data by using IN and NOT IN clause)
您可以检查更多细节:SQL到LINQ(案例7 -使用IN和NOT IN子句过滤数据)
#2
29
You can also use lambda:
你也可以用lambda:
var query = persons.Where(item => !listOfIds.Contains(item.Id));