Specifies how objects being loaded into the object context are merged with objects already in the object context.
public enum class MergeOption
public enum MergeOption
type MergeOption =
Public Enum MergeOption
Objects that do not exist in the object context are attached to the context. If an object is already in the context, the current and original values of object's properties in the entry are not overwritten with data source values. The state of the object's entry and state of properties of the object in the entry do not change. AppendOnly is the default merge option.
Objects are maintained in a Detached state and are not tracked in the ObjectStateManager. However, Entity Framework-generated entities and POCO entities with proxies maintain a reference to the object context to facilitate loading of related objects.
Objects that do not exist in the object context are attached to the context. If an object is already in the context, the current and original values of object's properties in the entry are overwritten with data source values. The state of the object's entry is set to Unchanged, no properties are marked as modified.
Objects that do not exist in the object context are attached to the context.
The Entity Framework only maintains a single instance of an object with a specific entity key in the cache. The EntityKey objects are immutable objects that represent object's identity. Entity keys are used to perform identity resolution in the object context. For more information, see Working with Entity Keys. If an entity with the same identity is already being tracked, the data coming from the data source and the data already in the state manager are merged according to the MergeOption of the query.
Additional information on
If the state of the entity is EntityState.Unchanged, the current and original values in the entry are overwritten with data source values. The state of the entity remains EntityState.Unchanged and no properties are marked as modified.
If the state of the entity is EntityState.Modified, the current values of modified properties are not overwritten with data source values. The original values of unmodified properties are overwritten with the values from the data source.
In .NET Framework 4, the Entity Framework compares the current values of unmodified properties with the values that were returned from the data source. If the values are not the same, the property is marked as modified.
In .NET Framework 3.5 SP1, the Entity Framework does not mark the property as modified even if the value in the data source is different.
Only modified properties are persisted to the data source when you call ObjectContext.SaveChanges.
To preserve the .NET Framework 3.5 SP1 behavior, set ObjectContextOptions.UseLegacyPreserveChangesBehavior to
PreserveChanges option can be used to resolve optimistic concurrency exceptions while preserving changes in the local context. For more information, see Saving Changes and Managing Concurrency.