Objects Model and Objects Relationship

For the purpose of this manual, DTO classes are arranged in the following functional categories:

Connection

In order to be able to configure and monitor the behavior of Pervasive.SQL engine users will have to connect to the engine first. This category provides functionality necessary to connect and disconnect to Pervasive.SQL database engines.

The DtoSession object manages the connection to a database engine.

Monitoring and Diagnostic

This category provides functionality to monitor Pervasive.SQL engines and clients and provides diagnostic information.

The DtoMonitor object and its descendents provide server monitoring and diagnostic information. You can also obtain engine information directly from DtoSession with the DtoEngineInformation object.

Configuration

This category allows the user to configure the Pervasive.SQL engines and clients. The DtoCategories collection and its descendents provide this functionality.

You can also add and remove product licenses using the DtoLicenseMgr object.

Catalog and Dictionary

Functionality grouped in this category allows users to create new databases, new data dictionaries and also define and drop tables, columns, and indexes.

The DtoDictionary class and its descendents provide catalog functionality.

DTO Object Tree

Many DTO objects are exposed as properties of other DTO objects. The relationship provides developers with a logical, tree-like structure that simplifies programming with automation controllers. Many objects can be referenced using the familiar dot notation used to access properties and methods.

The DTO object tree contains three main branches logically grouping objects for Configuration, Monitor and Catalog.

DTO2

A new DLL was released with Pervasive.SQL V8 SDK that added objects and new properties to existing objects. In order to maintain backward compatibility, a new DLL was created instead of adding this to the previous DTO.DLL. Both are installed and registered with Pervasive.SQL SDK and you can use either one to develop DTO applications. Using the previous DTO.DLL may be important to you if you cannot recompile your application to use the new DLL. However, if you continue to use the previous DTO.DLL, you cannot use the new objects or some new properties that were added to existing objects.

These new objects and properties are:

The following table shows usage information regarding the two versions: