Queryable.Concat<TSource> 方法

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static System::Linq::IQueryable<TSource> ^ Concat(System::Linq::IQueryable<TSource> ^ source1, System::Collections::Generic::IEnumerable<TSource> ^ source2);

public static System.Linq.IQueryable<TSource> Concat<TSource> (this System.Linq.IQueryable<TSource> source1, System.Collections.Generic.IEnumerable<TSource> source2);

static member Concat : System.Linq.IQueryable<'Source> * seq<'Source> -> System.Linq.IQueryable<'Source>

<Extension()>
Public Function Concat(Of TSource) (source1 As IQueryable(Of TSource), source2 As IEnumerable(Of TSource)) As IQueryable(Of TSource)

类型参数

参数

返回

一个包含两个输入序列的连接元素的 IQueryable<T>。

例外

示例

下面的代码示例演示如何使用 Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) 连接两个序列。

class Pet
{
    public string Name { get; set; }
    public int Age { get; set; }
}

// This method creates and returns an array of Pet objects.
static Pet[] GetCats()
{
    Pet[] cats = { new Pet { Name="Barley", Age=8 },
                   new Pet { Name="Boots", Age=4 },
                   new Pet { Name="Whiskers", Age=1 } };
    return cats;
}

// This method creates and returns an array of Pet objects.
static Pet[] GetDogs()
{
    Pet[] dogs = { new Pet { Name="Bounder", Age=3 },
                   new Pet { Name="Snoopy", Age=14 },
                   new Pet { Name="Fido", Age=9 } };
    return dogs;
}

public static void ConcatEx1()
{
    Pet[] cats = GetCats();
    Pet[] dogs = GetDogs();

    // Concatenate a collection of cat names to a
    // collection of dog names by using Concat().
    IEnumerable<string> query =
        cats.AsQueryable()
        .Select(cat => cat.Name)
        .Concat(dogs.Select(dog => dog.Name));

    foreach (string name in query)
        Console.WriteLine(name);
}

// This code produces the following output:
//
// Barley
// Boots
// Whiskers
// Bounder
// Snoopy
// Fido

' This method creates and returns an array of Pet objects.
Shared Function GetCats() As Pet()
    Dim cats() As Pet = _
        {New Pet With {.Name = "Barley", .Age = 8}, _
         New Pet With {.Name = "Boots", .Age = 4}, _
         New Pet With {.Name = "Whiskers", .Age = 1}}

    Return cats
End Function

' This method creates and returns an array of Pet objects.
Shared Function GetDogs() As Pet()
    Dim dogs() As Pet = _
        {New Pet With {.Name = "Bounder", .Age = 3}, _
         New Pet With {.Name = "Snoopy", .Age = 14}, _
         New Pet With {.Name = "Fido", .Age = 9}}

    Return dogs
End Function

Shared Sub ConcatEx1()
    Dim cats() As Pet = GetCats()
    Dim dogs() As Pet = GetDogs()

    ' Concatenate a collection of cat names to a
    ' collection of dog names by using Concat().
    Dim query As IEnumerable(Of String) = _
        cats.AsQueryable() _
        .Select(Function(cat) cat.Name) _
        .Concat(dogs.Select(Function(dog) dog.Name))

    For Each name As String In query
        MsgBox(name)
    Next
End Sub

Structure Pet
    Dim Name As String
    Dim Age As Integer
End Structure

' This code produces the following output:
'
' Barley
' Boots
' Whiskers
' Bounder
' Snoopy
' Fido

注解

方法 Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) 生成一个 ， MethodCallExpression 表示将调用 Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) 自身作为构造的泛型方法。 然后，MethodCallExpressionCreateQuery<TElement>(Expression)它将 传递给 由 Provider 参数的 属性表示的 的 source1 方法IQueryProvider。

由于执行表示调用 Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) 的表达式树而发生的查询行为取决于参数类型的 source1 实现。 预期的行为是，中的 source2 元素连接到 的 source1 元素以创建新序列。

适用于