Brief Description

Getting Started

The Dal assembly is used to work with various DBMS using SQL queries. Having studied this section, the user will be able to create a connection with the database server using the Fore language, to run SQL queries in synchronous and asynchronous modes and to work with database objects and their data. For more details about the block features, see the About the Dal Assembly section.

Assembly resources are described in the following subsections:

Before studying the Dal assembly, it is recommended to study the DBMS architecture which is used in work. The list of DBMS, based on which the Prognoz Platform 9 repository can be created, or connection to some data sources is executed, is given in the Supported DBMS subsection. It is also recommended to study the syntax of SQL commands to be executed from the application code and their differences when working with different DBMS. This information can be found in the specialized literature on the corresponding DBMS.

 

What's New

  • The driver is implemented to connect to SQLite DBMS. The DalSQLiteDriver class is used to work with this DBMS from Fore/Fore.NET.

  • The driver is implemented to connect and work with PostgreSQL DBMS. The DalPostgresDriver class is used to work with this DBMS from Fore/Fore.NET.

  • The driver is implemented to connect and work with Teradata DBMS. The DalTrdtDriver class is used to work with this DBMS from Fore/Fore.NET.

  • The driver is implemented to connect and work with Microsoft SQL Server 2012\2014 DBMS. The DalMsSql2012Driver class is used to work with this DBMS from Fore/Fore.NET.

Questions and Answers