NAVIGATE
Navigates over the relationship established between entities.
navigate(instance-expresssion, [relationship-type], [to-end [, from-end] ])
Arguments
- instance-expresssion
An instance of an entity.
- relationship-type
The type name of the relationship, from the conceptual schema definition language (CSDL) file. The relationship-type is qualified as <namespace>.<relationship type name>.
- to
The end of the relationship.
- from
The beginning of the relationship.
Return Value
If the cardinality of the to end is 1, the return value will be Ref<T>. If the cardinality of the to end is n, the return value will be Collection<Ref<T>>.
Remarks
Relationships are first-class constructs in the Entity Data Model (EDM). Relationships can be established between two or more entity types, and users can navigate over the relationship from one end (entity) to another. from and to are conditionally optional when there is no ambiguity in name resolution within the relationship.
NAVIGATE is valid in O and C space.
The general form of a navigation construct is the following:
navigate(instance-expresssion, relationship-type, [ to-end [, from-end ] ] )
For example:
Select o.Id, navigate(o, OrderCustomer, Customer, Order)
From LOB.Orders as o
Where OrderCustomer is the relationship, and Customer and Order are the to-end (customer) and from-end (order) of the relationship. If OrderCustomer was a n:1 relationship, then the result type of the navigate expression is Ref<Customer>.
The simpler form of this expression is the following:
Select o.Id, navigate(o, OrderCustomer)
From LOB.Orders as o
Similarly, in a query of the following form, The navigate expression would produce a Collection<Ref<Order>>.
Select c.Id, navigate(c, OrderCustomer, Order, Customer)
From LOB.Customers as c
The instance-expression must be an entity/ref type.
Example
The following Entity SQL query uses the NAVIGATE operator to navigate over the relationship established between Address and SalesOrderHeader entity types. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:
Follow the procedure in How to: Execute a Query that Returns StructuralType Results.
Pass the following query as an argument to the
ExecuteStructuralTypeQuerymethod:
SELECT address.AddressID, (SELECT VALUE DEREF(soh)
FROM NAVIGATE(address, AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID) AS soh)
FROM AdventureWorksEntities.Addresses AS address