Chapter 17. The database layer

In this chapter


Temporary tables

Surrogate keys

Alternate keys

Table relations

Table inheritance

Unit of Work

Date-effective framework

Full-text support

The QueryFilter API

Data partitions


The AX 2012 application runtime provides robust database features that make creating an enterprise resource planning (ERP) application much easier. Many powerful database features have been added to AX 2012. This chapter focuses on several of these new capabilities. The information provided here introduces the features, provides information about how to use them in an application, and, when appropriate, explains in detail how each feature works.

Many database features, such as optimistic concurrency ...

Get Inside Microsoft Dynamics AX 2012 R3 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.