Queryable.Any メソッド

定義

IQueryable<T> シーケンスの要素が存在するか、または条件を満たすかどうかを判断します。Determines whether any element of an IQueryable<T> sequence exists or satisfies a condition.

オーバーロード

Any<TSource>(IQueryable<TSource>)

シーケンスに要素が含まれているかどうかを判断します。Determines whether a sequence contains any elements.

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

シーケンスの任意の要素が条件を満たしているかどうかを判断します。Determines whether any element of a sequence satisfies a condition.

Any<TSource>(IQueryable<TSource>)

シーケンスに要素が含まれているかどうかを判断します。Determines whether a sequence contains any elements.

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 の要素の型。The type of the elements of source.

パラメーター

source
IQueryable<TSource>

空かどうかを確認するシーケンス。A sequence to check for being empty.

戻り値

ソース シーケンスに要素が含まれている場合は true。それ以外の場合は falsetrue if the source sequence contains any elements; otherwise, false.

例外

sourcenull です。source is null.

次のコード例では、Any<TSource>(IQueryable<TSource>) を使用して、シーケンスに要素が含まれているかどうかを確認する方法を示します。The following code example demonstrates how to use Any<TSource>(IQueryable<TSource>) to determine whether a sequence contains any elements.

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>) メソッドが返すブール値は、通常、where 句 (Visual Basic のWhere 句) の述語、または Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) メソッドへの直接の呼び出しで使用されます。The Boolean value that the Any<TSource>(IQueryable<TSource>) method returns is typically used in the predicate of a where clause (Where clause in Visual Basic) or a direct call to the Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) method. 次の例では、Any メソッドの使用方法を示します。The following example demonstrates this use of the Any method.

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>) メソッドは、構築されたジェネリックメソッドとしての呼び出し Any<TSource>(IQueryable<TSource>) 自体を表す MethodCallExpression を生成します。The Any<TSource>(IQueryable<TSource>) method generates a MethodCallExpression that represents calling Any<TSource>(IQueryable<TSource>) itself as a constructed generic method. 次に、source パラメーターの Provider プロパティによって表される IQueryProviderExecute<TResult>(Expression) メソッドに MethodCallExpression を渡します。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

Any<TSource>(IQueryable<TSource>) の呼び出しを表す式ツリーを実行した結果として発生するクエリ動作は、source パラメーターの型の実装によって異なります。The query behavior that occurs as a result of executing an expression tree that represents calling Any<TSource>(IQueryable<TSource>) depends on the implementation of the type of the source parameter. 期待される動作は、source に要素が含まれているかどうかを判断することです。The expected behavior is that it determines if source contains any elements.

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

シーケンスの任意の要素が条件を満たしているかどうかを判断します。Determines whether any element of a sequence satisfies a condition.

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 の要素の型。The type of the elements of source.

パラメーター

source
IQueryable<TSource>

条件を満たしているかどうかをテストする要素を含むシーケンス。A sequence whose elements to test for a condition.

predicate
Expression<Func<TSource,Boolean>>

各要素が条件を満たしているかどうかをテストする関数。A function to test each element for a condition.

戻り値

指定された述語でソース シーケンスの要素がテストに合格する場合は true。それ以外の場合は falsetrue if any elements in the source sequence pass the test in the specified predicate; otherwise, false.

例外

source 、または predicatenullです。source or predicate is null.

次のコード例は、Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) を使用して、シーケンス内のいずれかの要素が条件を満たすかどうかを判断する方法を示しています。The following code example demonstrates how to use Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) to determine whether any element in a sequence satisfies a condition.

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. 

注釈

このメソッドには、型引数が Func<T,TResult> 型の1つである Expression<TDelegate> 型のパラメーターが少なくとも1つ含まれています。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. これらのパラメーターでは、ラムダ式を渡すことができ、Expression<TDelegate>にコンパイルされます。For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) メソッドは、構築されたジェネリックメソッドとしての呼び出し Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 自体を表す MethodCallExpression を生成します。The Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) method generates a MethodCallExpression that represents calling Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) itself as a constructed generic method. 次に、source パラメーターの Provider プロパティによって表される IQueryProviderExecute<TResult>(Expression) メソッドに MethodCallExpression を渡します。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) の呼び出しを表す式ツリーを実行した結果として発生するクエリ動作は、source パラメーターの型の実装によって異なります。The query behavior that occurs as a result of executing an expression tree that represents calling Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) depends on the implementation of the type of the source parameter. 期待される動作は、source のいずれかの要素が predicateによって指定された条件を満たすかどうかを判断することです。The expected behavior is that it determines if any of the elements of source satisfy the condition specified by predicate.

適用対象