Queryable.Union Queryable.Union Queryable.Union Queryable.Union Method

Definizione

Produce l'unione insiemistica delle due sequenze.Produces the set union of two sequences.

Overload

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

Produce l'unione insiemistica delle due sequenze utilizzando l'operatore di confronto uguaglianze predefinito.Produces the set union of two sequences by using the default equality comparer.

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

Produce l'unione insiemistica di due sequenze utilizzando un oggetto IEqualityComparer<T> specificato.Produces the set union of two sequences by using a specified IEqualityComparer<T>.

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

Produce l'unione insiemistica delle due sequenze utilizzando l'operatore di confronto uguaglianze predefinito.Produces the set union of two sequences by using the default equality comparer.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static System::Linq::IQueryable<TSource> ^ Union(System::Linq::IQueryable<TSource> ^ source1, System::Collections::Generic::IEnumerable<TSource> ^ source2);
public static System.Linq.IQueryable<TSource> Union<TSource> (this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2);
static member Union : System.Linq.IQueryable<'Source> * seq<'Source> -> System.Linq.IQueryable<'Source>
<Extension()>
Public Function Union(Of TSource) (source1 As IQueryable(Of TSource), source2 As IEnumerable(Of TSource)) As IQueryable(Of TSource)

Parametri di tipo

TSource

Tipo degli elementi delle sequenze di input.The type of the elements of the input sequences.

Parametri

source1
IQueryable<TSource>

Una sequenza i cui elementi distinti formano il primo insieme per l'operazione di unione.A sequence whose distinct elements form the first set for the union operation.

source2
IEnumerable<TSource>

Una sequenza i cui elementi distinti formano il secondo insieme per l'operazione di unione.A sequence whose distinct elements form the second set for the union operation.

Restituisce

IQueryable<TSource>

Oggetto IQueryable<T> che contiene gli elementi di entrambe le sequenze di input, tranne i duplicati.An IQueryable<T> that contains the elements from both input sequences, excluding duplicates.

Eccezioni

source1 o source2 è null.source1 or source2 is null.

Esempi

Nell'esempio di codice riportato di seguito viene Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) illustrato come utilizzare per ottenere l'Unione di set di due sequenze.The following code example demonstrates how to use Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) to obtain the set union of two sequences.

int[] ints1 = { 5, 3, 9, 7, 5, 9, 3, 7 };
int[] ints2 = { 8, 3, 6, 4, 4, 9, 1, 0 };

// Get the set union of the items in the two arrays.
IEnumerable<int> union = ints1.AsQueryable().Union(ints2);

foreach (int num in union)
    Console.Write("{0} ", num);

/*
    This code produces the following output:

    5 3 9 7 8 6 4 1 0
*/

Dim ints1() As Integer = {5, 3, 9, 7, 5, 9, 3, 7}
Dim ints2() As Integer = {8, 3, 6, 4, 4, 9, 1, 0}

' Get the set union of the items in the two arrays.
Dim union = ints1.AsQueryable().Union(ints2)

Dim output As New System.Text.StringBuilder
For Each num As Integer In union
    output.Append(String.Format("{0} ", num))
Next

' Display the output.
MsgBox(output.ToString())

' This code produces the following output:

' 5 3 9 7 8 6 4 1 0

Commenti

Il Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) metodo genera un MethodCallExpression oggetto che rappresenta Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) la chiamata a se stesso come metodo generico costruito.The Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) method generates a MethodCallExpression that represents calling Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) itself as a constructed generic method. Passa MethodCallExpression IQueryProvider quindi al source1 metodo dell'oggetto rappresentato dalla proprietàdelparametro.Provider CreateQuery<TElement>(Expression)It then passes the MethodCallExpression to the CreateQuery<TElement>(Expression) method of the IQueryProvider represented by the Provider property of the source1 parameter.

Il comportamento della query che si verifica in seguito all'esecuzione di un albero delle espressioni che Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) rappresenta la chiamata dipende dall'implementazione del tipo source1 di parametro.The query behavior that occurs as a result of executing an expression tree that represents calling Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) depends on the implementation of the type of the source1 parameter. Il comportamento previsto è che l'Unione di set degli elementi in source1 e source2 venga restituita.The expected behavior is that the set union of the elements in source1 and source2 is returned.

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

Produce l'unione insiemistica di due sequenze utilizzando un oggetto IEqualityComparer<T> specificato.Produces the set union of two sequences by using a specified IEqualityComparer<T>.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static System::Linq::IQueryable<TSource> ^ Union(System::Linq::IQueryable<TSource> ^ source1, System::Collections::Generic::IEnumerable<TSource> ^ source2, System::Collections::Generic::IEqualityComparer<TSource> ^ comparer);
public static System.Linq.IQueryable<TSource> Union<TSource> (this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2, System.Collections.Generic.IEqualityComparer<TSource> comparer);
static member Union : System.Linq.IQueryable<'Source> * seq<'Source> * System.Collections.Generic.IEqualityComparer<'Source> -> System.Linq.IQueryable<'Source>
<Extension()>
Public Function Union(Of TSource) (source1 As IQueryable(Of TSource), source2 As IEnumerable(Of TSource), comparer As IEqualityComparer(Of TSource)) As IQueryable(Of TSource)

Parametri di tipo

TSource

Tipo degli elementi delle sequenze di input.The type of the elements of the input sequences.

Parametri

source1
IQueryable<TSource>

Una sequenza i cui elementi distinti formano il primo insieme per l'operazione di unione.A sequence whose distinct elements form the first set for the union operation.

source2
IEnumerable<TSource>

Una sequenza i cui elementi distinti formano il secondo insieme per l'operazione di unione.A sequence whose distinct elements form the second set for the union operation.

comparer
IEqualityComparer<TSource>

Oggetto IEqualityComparer<T> per confrontare i valori.An IEqualityComparer<T> to compare values.

Restituisce

IQueryable<TSource>

Oggetto IQueryable<T> che contiene gli elementi di entrambe le sequenze di input, tranne i duplicati.An IQueryable<T> that contains the elements from both input sequences, excluding duplicates.

Eccezioni

source1 o source2 è null.source1 or source2 is null.

Commenti

Il Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) metodo genera un MethodCallExpression oggetto che rappresenta Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) la chiamata a se stesso come metodo generico costruito.The Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) method generates a MethodCallExpression that represents calling Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) itself as a constructed generic method. Passa MethodCallExpression IQueryProvider quindi al source1 metodo dell'oggetto rappresentato dalla proprietàdelparametro.Provider CreateQuery<TElement>(Expression)It then passes the MethodCallExpression to the CreateQuery<TElement>(Expression) method of the IQueryProvider represented by the Provider property of the source1 parameter.

Il comportamento della query che si verifica in seguito all'esecuzione di un albero delle espressioni che Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) rappresenta la chiamata dipende dall'implementazione del tipo source1 di parametro.The query behavior that occurs as a result of executing an expression tree that represents calling Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) depends on the implementation of the type of the source1 parameter. Il comportamento previsto è che l'Unione di set degli elementi in source1 e source2 venga restituita.The expected behavior is that the set union of the elements in source1 and source2 is returned. Il comparer parametro viene utilizzato per confrontare i valori.The comparer parameter is used to compare values.

Si applica a