Export (0) Print
Expand All

ANYELEMENT

Extracts an element from a multivalued collection.


ANYELEMENT (expression)

expression
Any valid query expression that returns a collection to extract an element from.

A single element in the collection or an arbitrary element if the collection has more than one; if the collection is empty, returns null. Ifcollectionis a collection of type Collection<T>, then ANYELEMENT(collection) is a valid expression that yields an instance of type T.

ANYELEMENT extracts an arbitrary element from a multivalued collection. For example, the following example attempts to extract a singleton element from the set Customers.

ANYELEMENT(Customers)

The following Entity SQL query uses the ANYELEMENT operator to extract an element from a multivalued collection. 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:


ANYELEMENT((SELECT VALUE product from AdventureWorksEntities.Products as
product where product.ListPrice = @price))
    




Build Date:

2012-10-01
Show:
© 2015 Microsoft