# Managing Data Concurrency \[ **This document was written for WCF Services Version 1 Service Pack 2 and might not be up to date** \ Please see [Release Notes](https://github.com/OpenRIAServices/OpenRiaServices/releases) or [Changelog](https://github.com/OpenRIAServices/OpenRiaServices/blob/main/Changelog.md) for a list of changes since WCF RIA Services ] Open Ria Services supports optimistic concurrency to insure data consistency and relies on developers to provide the logic for handling potential conflicts that can occur when updating a data source. When you enable users to update or delete data, you should make sure that the data in the data source has not been changed by another process before you blindly update its values in the data record or delete it from the record. If you do not check whether the values have changed, you can unintentionally overwrite values set by another process and leave the data in an inconsistent state. Optimistic concurrency assumes that such conflicts are rare, but compares the value it got from the data source, and which it might change or delete, with the value that the source currently has. If they do not match, then an [OptimisticConcurrencyException](https://msdn.microsoft.com/en-us/library/Bb355991) is thrown and must be handled. For procedures on how to specify checking values for consistency, see [How to: Enable Optimistic Concurrency Checks](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/gg602748.md). For information on how to use explicit transactions to guarantee consistency, see [How to: Add Explicit Transactions to a Domain Service](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ee707364.md). ## Using the Concurrency Attributes By default, Open Ria Services does not pass the entire original entity, along with the changed values, to the data access layer to check for data concurrency. Instead, Open Ria Services stores and passes back only those members that are marked with the [RoundtripOriginalAttribute](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff423279.md) attribute, the [ConcurrencyCheckAttribute](https://msdn.microsoft.com/en-us/library/Dd538571) attribute, or the [TimestampAttribute](https://msdn.microsoft.com/en-us/library/Dd538368) attribute. Each of these attributes can be applied to properties in a metadata class, or to the metadata class itself, when working with the Entity Framework. They can also be applied directly to properties or classes of CLR types when working with POCO-defined data models. For more information, see [How to: Add Metadata Classes](/openriaservices/ee707348/ee707356/ee707339.md). When you build after applying these attributes, this will result in the respective attributes showing up on the client generated code for the properties or classes. When an attribute is applied to a class instead of to a property in the class, it is equivalent to applying the attribute to all of the members of the class. The [ConcurrencyCheckAttribute](https://msdn.microsoft.com/en-us/library/Dd538571) and the [TimestampAttribute](https://msdn.microsoft.com/en-us/library/Dd538368) attributes also cause the [RoundtripOriginalAttribute](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff423279.md) to show up on the client property or class to which they have been applied in the domain service metadata. This implementation enables you to optimize the performance of your application by specifying only those members that you want to participate in the concurrency check. {% hint style="warning" %} **Important:** If the [KeyAttribute](https://msdn.microsoft.com/en-us/library/Dd382103) is applied to the property of an entity type, this also adds the [RoundtripOriginalAttribute](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff423279\(v=vs.91\).md) to the corresponding property generated on the client when the project is built. So in domain services generated from a database source with the **Add New Domain Service Class** wizard, this is the default behavior for the properties that serve as the entity key. {% endhint %} When the [RoundtripOriginalAttribute](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff423279.md) is applied, the data access layer compares the original value in the data source recoded when the data was retrieved with the current value of the data in the data source. If the values are the same, then the data in the store has not changed, and the data access layer updates or deletes the data. If the data has changed, a conflict occurs and an [OptimisticConcurrencyException](https://msdn.microsoft.com/en-us/library/Bb355991) is thrown. Information about the conflict is stored in the [EntityConflict](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff422579.md) property of the entity that no longer has current data. If you apply the [ExcludeAttribute](https://github.com/OpenRIAServices/OpenRiaServices/tree/82784ac86a5b1cdd95b784ccdb3a00baefcaa7de/docs/ff422771.md) attribute to a member in an entity that can be updated or deleted from the client, that member cannot be used for optimistic concurrency checks. When you exclude the member, the correct original value is not stored for that member, and the update operation will always fail as a result. For more information, see [How to: Add Metadata Classes](/openriaservices/ee707348/ee707356/ee707339.md). ### Handling the OptimisticConcurrencyException When data changes in the object cache conflict with changes that were made in the data source after objects were added to or refreshed in the cache, the whole transaction is rolled-back. When an [OptimisticConcurrencyException](https://msdn.microsoft.com/en-us/library/Bb355991) occurs, you should handle it by specifying whether the conflict should be resolved by preserving data in the object data (ClientWins) or by updating the object cache with the data from the data source (StoreWins). For guidance on how to do this, see [Saving Changes and Managing Concurrency](http://go.microsoft.com/fwlink/?linkid=210676) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://openriaservices.gitbook.io/openriaservices/ee707348/ee707356/gg602751.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.