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 Microsoft Dynamics AX 2012 application run time provides robust database features that make creating an enterprise resource planning (ERP) application much easier. Many new and powerful database features have been added to Microsoft Dynamics 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 ...

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

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