How to: Navigate Relationships with Navigate Operator (EntityClient)

This topic provides an example of how to execute a command against an Entity Data Model by using EntityCommand, and how to retrieve the RefType results by using EntityDataReader.

To run the code in this example

  1. Add the AdventureWorks Sales Model to your project and configure your project to use the Entity Framework. To do this, do one of the following:

  2. In the code page for your application, add the following using statements (Imports in Visual Basic):.

    using System;
    using System.Collections.Generic;
    using System.Collections;
    using System.Data.Common;
    using System.Data;
    using System.IO;
    using System.Data.SqlClient;
    using System.Data.EntityClient;
    using AdventureWorksModel;
    using System.Data.Metadata.Edm;
    
    

Example

The following example shows how to navigate relationships in Entity SQL by using the NAVIGATE (Entity SQL) operator. The Navigate operator takes the following parameters: an instance of an entity, the relationship-type, the end of the relationship, and the beginning of the relationship. The simplier version of the Navigate operator takes an instance of an entity and the relationship-type. The following example shows how to use the simplier version of the Navigate operator.

using (EntityConnection conn =
    new EntityConnection("name=AdventureWorksEntities"))
{
    conn.Open();
    try
    {
        // Create an EntityCommand.
        using (EntityCommand cmd = conn.CreateCommand())
        {
            // Create an Entity SQL query.
            string esqlQuery =
                @"SELECT address.AddressID, (SELECT VALUE DEREF(soh) FROM 
              NAVIGATE(address, AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID) 
              AS soh) FROM AdventureWorksEntities.Address AS address";

            cmd.CommandText = esqlQuery;

            // Execute the command.
            using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
            {
                // Start reading.
                while (rdr.Read())
                {
                    Console.WriteLine(rdr["AddressID"]);
                }
            }
        }
    }
    catch (EntityException ex)
    {
        Console.WriteLine(ex.ToString());
    }
    conn.Close();
}

See Also

Community Additions

Show: