Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Queryable.UnionBy Method

Definition

Namespace:
System.Linq
Assemblies:
netstandard.dll, System.Linq.Queryable.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

Name Description
UnionBy<TSource,TKey>(IQueryable<TSource>, IEnumerable<TSource>, Expression<Func<TSource,TKey>>)

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

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

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

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

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

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

public:
generic <typename TSource, typename TKey>
[System::Runtime::CompilerServices::Extension]
 static System::Linq::IQueryable<TSource> ^ UnionBy(System::Linq::IQueryable<TSource> ^ source1, System::Collections::Generic::IEnumerable<TSource> ^ source2, System::Linq::Expressions::Expression<Func<TSource, TKey> ^> ^ keySelector);
public static System.Linq.IQueryable<TSource> UnionBy<TSource,TKey>(this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector);
[System.Diagnostics.CodeAnalysis.RequiresDynamicCode("Enumerating collections as IQueryable can require creating new generic types or methods, which requires creating code at runtime. This may not work when AOT compiling.")]
public static System.Linq.IQueryable<TSource> UnionBy<TSource,TKey>(this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector);
static member UnionBy : System.Linq.IQueryable<'Source> * seq<'Source> * System.Linq.Expressions.Expression<Func<'Source, 'Key>> -> System.Linq.IQueryable<'Source>
[<System.Diagnostics.CodeAnalysis.RequiresDynamicCode("Enumerating collections as IQueryable can require creating new generic types or methods, which requires creating code at runtime. This may not work when AOT compiling.")>]
static member UnionBy : System.Linq.IQueryable<'Source> * seq<'Source> * System.Linq.Expressions.Expression<Func<'Source, 'Key>> -> System.Linq.IQueryable<'Source>
<Extension()>
Public Function UnionBy(Of TSource, TKey) (source1 As IQueryable(Of TSource), source2 As IEnumerable(Of TSource), keySelector As Expression(Of Func(Of TSource, TKey))) As IQueryable(Of TSource)

Type Parameters

TSource

The type of the elements of the input sequences.

TKey

The type of key to identify elements by.

Parameters

source1
IQueryable<TSource>

An IQueryable<T> whose distinct elements form the first set for the union.

source2
IEnumerable<TSource>

An IEnumerable<T> whose distinct elements form the second set for the union.

keySelector
Expression<Func<TSource,TKey>>

A function to extract the key for each element.

Returns

IQueryable<TSource>

An IEnumerable<T> that contains the elements from both input sequences, excluding duplicates.

Attributes

Exceptions

source1 or source2 is null.

Applies to

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

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

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

public:
generic <typename TSource, typename TKey>
[System::Runtime::CompilerServices::Extension]
 static System::Linq::IQueryable<TSource> ^ UnionBy(System::Linq::IQueryable<TSource> ^ source1, System::Collections::Generic::IEnumerable<TSource> ^ source2, System::Linq::Expressions::Expression<Func<TSource, TKey> ^> ^ keySelector, System::Collections::Generic::IEqualityComparer<TKey> ^ comparer);
public static System.Linq.IQueryable<TSource> UnionBy<TSource,TKey>(this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector, System.Collections.Generic.IEqualityComparer<TKey>? comparer);
[System.Diagnostics.CodeAnalysis.RequiresDynamicCode("Enumerating collections as IQueryable can require creating new generic types or methods, which requires creating code at runtime. This may not work when AOT compiling.")]
public static System.Linq.IQueryable<TSource> UnionBy<TSource,TKey>(this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2, System.Linq.Expressions.Expression<Func<TSource,TKey>> keySelector, System.Collections.Generic.IEqualityComparer<TKey>? comparer);
static member UnionBy : System.Linq.IQueryable<'Source> * seq<'Source> * System.Linq.Expressions.Expression<Func<'Source, 'Key>> * System.Collections.Generic.IEqualityComparer<'Key> -> System.Linq.IQueryable<'Source>
[<System.Diagnostics.CodeAnalysis.RequiresDynamicCode("Enumerating collections as IQueryable can require creating new generic types or methods, which requires creating code at runtime. This may not work when AOT compiling.")>]
static member UnionBy : System.Linq.IQueryable<'Source> * seq<'Source> * System.Linq.Expressions.Expression<Func<'Source, 'Key>> * System.Collections.Generic.IEqualityComparer<'Key> -> System.Linq.IQueryable<'Source>
<Extension()>
Public Function UnionBy(Of TSource, TKey) (source1 As IQueryable(Of TSource), source2 As IEnumerable(Of TSource), keySelector As Expression(Of Func(Of TSource, TKey)), comparer As IEqualityComparer(Of TKey)) As IQueryable(Of TSource)

Type Parameters

TSource

The type of the elements of the input sequences.

TKey

The type of key to identify elements by.

Parameters

source1
IQueryable<TSource>

An IQueryable<T> whose distinct elements form the first set for the union.

source2
IEnumerable<TSource>

An IEnumerable<T> whose distinct elements form the second set for the union.

keySelector
Expression<Func<TSource,TKey>>

A function to extract the key for each element.

comparer
IEqualityComparer<TKey>

The IEqualityComparer<T> to compare values.

Returns

IQueryable<TSource>

An IEnumerable<T> that contains the elements from both input sequences, excluding duplicates.

Attributes

Exceptions

source1 or source2 is null.

Applies to


Feedback

Was this page helpful?