EntityKey Constructor (String, IEnumerable(KeyValuePair(String, Object)))

EntityKey Constructor (String, IEnumerable<KeyValuePair<String, Object>>)


Initializes a new instance of the EntityKey class with an entity set name and a generic T:System.Collections.Generic.KeyValuePair collection.

Namespace:   System.Data
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

public EntityKey(
	string qualifiedEntitySetName,
	IEnumerable<KeyValuePair<stringobject>> entityKeyValues


Type: System.String

A String that is the entity set name qualified by the entity container name.

Type: System.Collections.Generic.IEnumerable<KeyValuePair<StringObject>>

A generic T:System.Collections.Generic.KeyValuePair collection.

Each key/value pair has a property name as the key and the value of that property as the value. There should be one pair for each property that is part of the EntityKey. The order of the key/value pairs is not important, but each key property should be included. The property names are simple names that are not qualified with an entity type name or the schema name.

This example is based on the AdventureWorks Sales Model. The example shows you how to create and use an EntityKey.

using (AdventureWorksEntities context =
    new AdventureWorksEntities())
        // Create the key that represents the order.
        EntityKey orderKey =
            new EntityKey("AdventureWorksEntities.SalesOrderHeaders",
                "SalesOrderID", orderId);

        // Create the stand-in SalesOrderHeader object
        // based on the specified SalesOrderID.
        SalesOrderHeader order = new SalesOrderHeader();
        order.EntityKey = orderKey;

        // Assign the ID to the SalesOrderID property to matche the key.
        order.SalesOrderID = (int)orderKey.EntityKeyValues[0].Value;

        // Attach the stand-in SalesOrderHeader object.

        // Create a new SalesOrderDetail object.
        // You can use the static CreateObjectName method (the Entity Framework
        // adds this method to the generated entity types) instead of the new operator:
        // SalesOrderDetail.CreateSalesOrderDetail(1, 0, 2, 750, 1, (decimal)2171.2942, 0, 0,
        //                                         Guid.NewGuid(), DateTime.Today));
        SalesOrderDetail detail = new SalesOrderDetail
            SalesOrderID = orderId,
            SalesOrderDetailID = 0,
            OrderQty = 2,
            ProductID = 750,
            SpecialOfferID = 1,
            UnitPrice = (decimal)2171.2942,
            UnitPriceDiscount = 0,
            LineTotal = 0,
            rowguid = Guid.NewGuid(),
            ModifiedDate = DateTime.Now


    catch (InvalidOperationException)
        Console.WriteLine("Ensure that the key value matches the value of the object's ID property.");
    catch (UpdateException)
        Console.WriteLine("An error has occured. Ensure that an object with the '{0}' key value exists.",

.NET Framework
Available since 3.5
Return to top
© 2015 Microsoft