Defining and Managing Relationships
In the Entity Framework, an entity can be related to other entities through an association. This relationship between entities is defined in the conceptual model by the Association element. Each relationship contains two ends that describe the entity type and the multiplicity of the type (one, zero-or-one, or many). The relationship may be governed by a referential constraint, which describes which end in the relationship is a principal role and which is a dependent role.
Starting with the .NET Framework version 4, you can include foreign keys in the conceptual model. The Include foreign key columns in the model option in the Entity Data Model Wizard is selected by default. When this option is selected, the generated entity objects have scalar properties that map to foreign key columns. With foreign key properties included, you can create or change a relationship by modifying the foreign key value on a dependent object. This kind of association is called a foreign key association.
When foreign key columns are not included in the conceptual model, the association information is managed as an independent object. Relationships are tracked through object references instead of foreign key properties, and are represented as an ObjectStateEntry object in the ObjectStateManager.This type of association is called an independent association. The most common way to modify an independent association is to modify the navigation properties that are generated for each entity that participates in the association.
In both types of associations, every object can have a navigation property for every relationship in which it participates. The navigation properties allow you to navigate and manage relationships in both directions, returning either a reference object, if the multiplicity is either one or zero-or-one, or a collection of objects, if the multiplicity is many.
You can choose to use one or both types of associations in your model. However, if you include a table that contains only foreign keys (also called a pure join table) in your model, an independent association will be used to manage the pure many-to-many relationship even if you specified to use a foreign key association in your model. The Entity Data Model Wizard does not create an entity that maps to a pure join table.
Creating and Modifying Relationships
In the Entity Framework, you can create and modify relationships in several ways.
By assigning a new object to a navigation property. The following code creates a relationship between an
customer. If the objects are attached to the object context, the
orderis added to the
customer.Orderscollection, and the corresponding foreign key property on the
orderobject is set to the key property value of the customer:
order.Customer = customer
By deleting or adding an object in an entity collection. For example, you can use the Add method to add an object of type Order to the
customer.Orderscollection. This operation creates a relationship between a particular
customer. If the objects are attached to the object context, the customer reference and the foreign key property on the
orderobject will be set to the appropriate
In foreign key associations, you can assign a new value to a foreign key property, as in the following example.
Note: If the reference is in the added state, the reference navigation property will not be synchronized with the key values of a new object until SaveChanges is called. Synchronization does not occur because the object context does not contain permanent keys for added objects until they are saved. For more information, see Working with Entity Keys. If you must have new objects fully synchronized as soon as you set the relationship, use one of the previous two methods.
order.CustomerID = newCustomer.CustomerID order.CustomerID = null
By creating the entity key for a specific object. If the object with this key already exists in the object context, the CreateEntityKey method will return the EntityKey of the existing object. This method is provided for backward compatibility with the .NET Framework 3.5 SP1.
order.CustomerReference.EntityKey = ctx.CreateEntityKey("EntitySetName", newObject)
When you change the relationship of the objects attached to the object context by using one of the methods described above, the Entity Framework needs to keep foreign keys, references, and collections in sync. The Entity Framework will manage this synchronization for certain types of eligible objects:
Entity objects that are code generated by the Entity Data Model tools.
Custom objects that implement IEntityWithChangeTracker interface.
POCO entities with proxies. For more information, see Requirements for Creating POCO Proxies.
If you are using POCO entities without proxies, you must call the DetectChanges method to synchronize the related objects in the object context. If you are working with disconnected objects you must manually manage the synchronization.
The following examples show how to use the foreign key property and the navigation property to associate the related objects. With foreign key associations, you can use both methods to change create or modify relationships. With independent associations, you cannot use the foreign key property.
In an independent relationship, changing the relationship will not update the state of the dependent object.
In both foreign key and independent associations, concurrency checks are based on the entity keys and other entity properties that are defined in the conceptual layer by setting the ConcurrencyMode attribute to fixed.
In an independent association, however, the relationship concurrency check is always performed on objects on both ends of a relationship. This check verifies the original key values of the related ends. If you modify the relationship while the object is detached from the object context, you must recreate the original relationship (either by re-querying or carrying the original key values), attach the object to the object context, and then make the appropriate changes to your relationship in that object context.
Working with Overlapping Keys
Overlapping keys are composite keys where some properties in the key are also part of another key in the entity. You cannot have an overlapping key in an independent association. To change a foreign key association that includes overlapping keys, we recommend that you modify the foreign key values instead of using the object references.
Loading Related Objects
In a foreign key association, when you load a related end of a dependent object, the related object will be loaded based on the foreign key value of the dependent that is currently in memory:
// Get the order where currently AddressID = 1. SalesOrderHeader order = context.SalesOrderHeaders.First(o=>o.SalesOrderID == orderId); // Use BillToAddressID foreign key property // to change the association. order.BillToAddressID = 2 order.AddressReference.Load();
In an independent association, the related end of a dependent object is queried based on the foreign key value that is currently in the database. However, if the relationship was modified, and the reference property on the dependent object points to a different principal object that is loaded in the object context, the Entity Framework will try to create a relationship as it is defined on the client.
Considerations for Identifying and Non-identifying Relationships
When a primary key of the principal entity is also part of the primary key of the dependent entity, the relationship is an identifying relationship. In an identifying relationship the dependent entity cannot exist without the principal entity. This constraint causes the following behaviors in an identifying relationship:
Deleting the principal object also deletes the dependent object. This is the same behavior as specifying
<OnDelete Action="Cascade" />in the model for the relationship.
Removing the relationship deletes the dependent object. Calling the Remove method on the EntityCollection marks both the relationship and the dependent object for deletion.
When you create a new dependent object, the principal object must exist in the object context or in the data source before you call SaveChanges. If the principal object does not exist, an InvalidOperationException will be raised.
In a non-identifying relationship, if the model is based on foreign key associations, deleting the principal object will set foreign keys of dependents to null if they are nullable. For dependent objects that cannot exist without a principal, you must manually delete the dependent objects or assign a new principal object to the dependent objects. Alternatively, you can specify
<OnDelete Action="Cascade" /> in the model to ensure that dependent objects are deleted when you delete the related principal object.