Data Integrity

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

There are a number of concepts and features to consider when adding, modifying, or deleting data to ensure that the integrity and consistency of the data is maintained. These include:

  • Using table DeleteAction elements.

  • Using the forUpdate keyword correctly in select statements.

  • Enabling transactions in your code.

  • Avoiding deadlocks.

  • Implementing Optimistic Concurrency Control (OCC).

In This Section

Maintaining Data Integrity

Deadlocks

Optimistic Concurrency Control

How to: Use the UnitOfWork Class to Manage Database Transactions

Walkthrough: Verifying E-signatures on SQL update_recordset by Modifying Info .collectESignature

See also

Database for Microsoft Dynamics AX

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.