Queryable.Any 方法

定义

确定 IQueryable<T> 序列中的任何元素是否都存在或满足条件。

重载

Any<TSource>(IQueryable<TSource>)

确定序列是否包含任何元素。

Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

确定序列中是否存在任意一个元素满足条件。

Any<TSource>(IQueryable<TSource>)

确定序列是否包含任何元素。

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static bool Any(System::Linq::IQueryable<TSource> ^ source);
public static bool Any<TSource> (this System.Linq.IQueryable<TSource> source);
static member Any : System.Linq.IQueryable<'Source> -> bool
<Extension()>
Public Function Any(Of TSource) (source As IQueryable(Of TSource)) As Boolean

类型参数

TSource

source 的元素类型。

参数

source
IQueryable<TSource>

要检查是否为空的序列。

返回

Boolean

如果源序列包含任何元素,则为 true;否则为 false

例外

sourcenull

示例

下面的代码示例演示如何使用 Any<TSource>(IQueryable<TSource>) 来确定序列是否包含任何元素。

List<int> numbers = new List<int> { 1, 2 };

// Determine if the list contains any elements.
bool hasElements = numbers.AsQueryable().Any();

Console.WriteLine("The list {0} empty.",
    hasElements ? "is not" : "is");

// This code produces the following output:
//
// The list is not empty.
Dim numbers As New List(Of Integer)(New Integer() {1, 2})

' Determine if the list contains any elements.
Dim hasElements As Boolean = numbers.AsQueryable().Any()

MsgBox(String.Format("The list {0} empty.", _
    IIf(hasElements, "is not", "is")))

' This code produces the following output:
'
' The list is not empty.

方法返回的Any<TSource>(IQueryable<TSource>)布尔值通常用于 Visual Basic) 中子句 (Where子句的谓词where或对方法的Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)直接调用。 下面的示例演示了 方法的 Any 此用法。

class Pet
{
    public string Name { get; set; }
    public int Age { get; set; }
}
class Person
{
    public string LastName { get; set; }
    public Pet[] Pets { get; set; }
}

public static void AnyEx2()
{
    List<Person> people = new List<Person>
        { new Person { LastName = "Haas",
                       Pets = new Pet[] { new Pet { Name="Barley", Age=10 },
                                          new Pet { Name="Boots", Age=14 },
                                          new Pet { Name="Whiskers", Age=6 }}},
          new Person { LastName = "Fakhouri",
                       Pets = new Pet[] { new Pet { Name = "Snowball", Age = 1}}},
          new Person { LastName = "Antebi",
                       Pets = new Pet[] { }},
          new Person { LastName = "Philips",
                       Pets = new Pet[] { new Pet { Name = "Sweetie", Age = 2},
                                          new Pet { Name = "Rover", Age = 13}} }
        };

    // Determine which people have a non-empty Pet array.
    IEnumerable<string> names = from person in people
                                where person.Pets.AsQueryable().Any()
                                select person.LastName;

    foreach (string name in names)
        Console.WriteLine(name);

    /* This code produces the following output:

       Haas
       Fakhouri
       Philips
    */
}
Structure Pet
    Public Name As String
    Public Age As Integer
End Structure

Structure Person
    Public LastName As String
    Public Pets() As Pet
End Structure

Sub AnyEx2()
    Dim people As New List(Of Person)(New Person() _
        {New Person With {.LastName = "Haas", _
                          .Pets = New Pet() {New Pet With {.Name = "Barley", .Age = 10}, _
                                             New Pet With {.Name = "Boots", .Age = 14}, _
                                             New Pet With {.Name = "Whiskers", .Age = 6}}}, _
          New Person With {.LastName = "Fakhouri", _
                           .Pets = New Pet() {New Pet With {.Name = "Snowball", .Age = 1}}}, _
          New Person With {.LastName = "Antebi", _
                           .Pets = New Pet() {}}, _
          New Person With {.LastName = "Philips", _
                           .Pets = New Pet() {New Pet With {.Name = "Sweetie", .Age = 2}, _
                                              New Pet With {.Name = "Rover", .Age = 13}}}})

    ' Determine which people have a non-empty Pet array.
    Dim names = From person In people _
                Where person.Pets.AsQueryable().Any() _
                Select person.LastName

    For Each name As String In names
        Console.WriteLine(name)
    Next

    ' This code produces the following output:
    '
    ' Haas
    ' Fakhouri
    ' Philips

End Sub

注解

方法 Any<TSource>(IQueryable<TSource>) 生成一个 , MethodCallExpression 它将调用 Any<TSource>(IQueryable<TSource>) 自身表示为构造的泛型方法。 然后,MethodCallExpressionExecute<TResult>(Expression)它将 传递给 由 Provider 参数的 属性表示的 的 source 方法IQueryProvider

由于执行表示调用 Any<TSource>(IQueryable<TSource>) 的表达式树而发生的查询行为取决于参数类型的 source 实现。 预期行为是确定是否 source 包含任何元素。

适用于

Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

确定序列中是否存在任意一个元素满足条件。

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static bool Any(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, bool> ^> ^ predicate);
public static bool Any<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,bool>> predicate);
static member Any : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, bool>> -> bool
<Extension()>
Public Function Any(Of TSource) (source As IQueryable(Of TSource), predicate As Expression(Of Func(Of TSource, Boolean))) As Boolean

类型参数

TSource

source 的元素类型。

参数

source
IQueryable<TSource>

要测试其元素是否满足条件的序列。

predicate
Expression<Func<TSource,Boolean>>

用于测试每个元素是否满足条件的函数。

返回

Boolean

如果源序列中存在元素通过了指定谓词中的测试,则为 true;否则为 false

例外

sourcepredicatenull

示例

下面的代码示例演示如何使用Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)以确定序列中是否有任意一个元素满足条件。

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

public static void AnyEx3()
{
    // Create an array of Pet objects.
    Pet[] pets =
        { new Pet { Name="Barley", Age=8, Vaccinated=true },
          new Pet { Name="Boots", Age=4, Vaccinated=false },
          new Pet { Name="Whiskers", Age=1, Vaccinated=false } };

    // Determine whether any pets over age 1 are also unvaccinated.
    bool unvaccinated =
        pets.AsQueryable().Any(p => p.Age > 1 && p.Vaccinated == false);

    Console.WriteLine(
        "There {0} unvaccinated animals over age one.",
        unvaccinated ? "are" : "are not any");
}

// This code produces the following output:
//
//  There are unvaccinated animals over age one.
Structure Pet
    Dim Name As String
    Dim Age As Integer
    Dim Vaccinated As Boolean
End Structure

Shared Sub AnyEx3()
    ' Create an array of Pet objects.
    Dim pets() As Pet = _
        {New Pet With {.Name = "Barley", .Age = 8, .Vaccinated = True}, _
         New Pet With {.Name = "Boots", .Age = 4, .Vaccinated = False}, _
         New Pet With {.Name = "Whiskers", .Age = 1, .Vaccinated = False}}

    ' Determine whether any pets over age 1 are also unvaccinated.
    Dim unvaccinated As Boolean = _
    pets.AsQueryable().Any(Function(p) p.Age > 1 And p.Vaccinated = False)

    MsgBox(String.Format( _
        "There {0} unvaccinated animals over age one.", _
        IIf(unvaccinated, "are", "are not any") _
    ))
End Sub

' This code produces the following output:
'
'  There are unvaccinated animals over age one.

注解

此方法至少有一个类型的 Expression<TDelegate> 参数,其类型参数是类型之 Func<T,TResult> 一。 对于这些参数,可以传入 lambda 表达式,它将编译为 Expression<TDelegate>

方法 Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 生成一个 , MethodCallExpression 它将调用 Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 自身表示为构造的泛型方法。 然后,MethodCallExpressionExecute<TResult>(Expression)它将 传递给 由 Provider 参数的 属性表示的 的 source 方法IQueryProvider

由于执行表示调用 Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 的表达式树而发生的查询行为取决于参数类型的 source 实现。 预期行为是它确定 的任何 source 元素是否满足 指定的 predicate条件。

适用于