Queryable.ExceptBy Method

Definition

Overloads

ExceptBy<TSource,TKey>(IQueryable<TSource>, IEnumerable<TKey>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>)

Produces the set difference of two sequences according to a specified key selector function.

ExceptBy<TSource,TKey>(IQueryable<TSource>, IEnumerable<TKey>, Expression<Func<TSource,TKey>>)

Produces the set difference of two sequences according to a specified key selector function.

ExceptBy<TSource,TKey>(IQueryable<TSource>, IEnumerable<TKey>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>)

Source:
Queryable.cs
Source:
Queryable.cs
Source:
Queryable.cs

Produces the set difference of two sequences according to a specified key selector function.

public static System.Linq.IQueryable<TSource> ExceptBy<TSource,TKey> (this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TKey> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector, System.Collections.Generic.IEqualityComparer<TKey>? comparer);

Type Parameters

TSource

The type of the elements of the input sequence.

TKey

The type of key to identify elements by.

Parameters

source1
IQueryable<TSource>

An IQueryable<T> whose keys that are not also in source2 will be returned.

source2
IEnumerable<TKey>

An IEnumerable<T> whose keys that also occur in the first sequence will cause those elements to be removed from the returned sequence.

keySelector
Expression<Func<TSource,TKey>>

A function to extract the key for each element.

comparer
IEqualityComparer<TKey>

An IEqualityComparer<T> to compare keys.

Returns

IQueryable<TSource>

A IQueryable<T> that contains the set difference of the elements of two sequences.

Applies to

.NET 9 and other versions
Product Versions
.NET 6, 7, 8, 9

ExceptBy<TSource,TKey>(IQueryable<TSource>, IEnumerable<TKey>, Expression<Func<TSource,TKey>>)

Source:
Queryable.cs
Source:
Queryable.cs
Source:
Queryable.cs

Produces the set difference of two sequences according to a specified key selector function.

public static System.Linq.IQueryable<TSource> ExceptBy<TSource,TKey> (this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TKey> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector);

Type Parameters

TSource

The type of the elements of the input sequence.

TKey

The type of key to identify elements by.

Parameters

source1
IQueryable<TSource>

An IQueryable<T> whose keys that are not also in source2 will be returned.

source2
IEnumerable<TKey>

An IEnumerable<T> whose keys that also occur in the first sequence will cause those elements to be removed from the returned sequence.

keySelector
Expression<Func<TSource,TKey>>

A function to extract the key for each element.

Returns

IQueryable<TSource>

A IQueryable<T> that contains the set difference of the elements of two sequences.

Applies to

.NET 9 and other versions
Product Versions
.NET 6, 7, 8, 9