使用LINQ获得两个列表之间的差异

时间:2023-01-17 21:30:59

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