EXISTS (Entity SQL)

  • Article

Determines if a collection is empty.

Syntax

[NOT] EXISTS ( expression )

Arguments

expression Any valid expression that returns a collection.

NOT Specifies that the result of EXISTS be negated.

Return Value

true if the collection is not empty; otherwise, false.

Remarks

EXISTS is one of the Entity SQL set operators. All Entity SQL set operators are evaluated from left to right. For precedence information for the Entity SQL set operators, see EXCEPT.

Example

The following Entity SQL query uses the EXISTS operator to determine whether the collection is empty. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:

  1. Follow the procedure in How to: Execute a Query that Returns StructuralType Results.

  2. Pass the following query as an argument to the ExecuteStructuralTypeQuery method:

SELECT VALUE name FROM AdventureWorksEntities.Products 
    AS name WHERE exists(SELECT A FROM AdventureWorksEntities.Products 
    AS A WHERE A.ListPrice < @price1)

See also