About the Dal Assembly

This section contains description of the Dal assembly used to work with DBMS by means of SQL queries. The assembly contains the implementation of classes that provide access to the DBMS using any drivers supported by Prognoz Platform 9. Using the required driver, create a connection to the DBMS and create a command for launching SQL queries and returning their execution results. The obtained data can be transferred to the application under development, processed there and saved back to the database.

The main interfaces of the Dal assembly are:

• IDalDriver. The basic interface that contains the method for creating a connection description.

• IDalConnectionDescriptor, IDalConnectionDescriptor2, IDalConnectionDescriptorExt. Interfaces for describing connection with the DBMS.

• IDalConnection, IDalConnection2, IDalConnectionExt. Interfaces for working with the created repository.

• IDalCommand, IDalCommand2, IDalCommandEx. Interfaces for working with commands used to execute SQL queries.

• IDalCursor. The interface that contains properties and methods used to work with the resulting data cursor.

• IDalCommandTask. The interface that describes the task used to execute SQL queries in the asynchronous mode.

To find more details on working with the DBMS using SQL queries, use the following sections:

• Creating a Connection with DBMS.

• SQL Query Run Command.

• Executing SQL Queries in the Asynchronous Mode.

• Executing SQL Queries with Runtime Error Check.

• Running Stored Procedures and Functions.

• Working with Cursors in SQL Query Runtime Results.

• Working with Time Tables.

See also:

Dal Assembly Interfaces | Dal Assembly Enumerations | Dal Assembly Classes