FLATTEN

FLATTEN (Entity SQL)

 

Converts a collection of collections into a flattened collection. The new collection contains all the same elements as the old collection, but without a nested structure.


FLATTEN ( collection )

collection

Any valid expression that returns a collection of value collections to flatten into a single collection.

FLATTEN is one of the Entity SQL set operators. All Entity SQL set operators are evaluated from left to right. See EXCEPT (Entity SQL) for precedence information for the Entity SQL set operators.

Example

The following Entity SQL query uses the FLATTEN operator to convert a collection of collections into a flattened collection. 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:

FLATTEN(SELECT VALUE c.SalesOrderHeaders From 
    AdventureWorksEntities.Contacts as c)
Show:
© 2016 Microsoft