Inside Microsoft Dynamics AX 2012 R3

Chapter 17. The database layer

In this chapter

Introduction

Temporary tables

Surrogate keys

Alternate keys

Table relations

Table inheritance

Unit of Work

Date-effective framework

Full-text support

The QueryFilter API

Data partitions

Introduction

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 ...