Description

dotConnect Universal is an all-encompassing enterprise-grade connector that applies a unified code base to enable access to multiple database systems in .NET applications of all levels. It delivers the broadest possible compatibility with database server versions and .NET platforms, and easy integration with a number of IDEs, most notably Microsoft Visual Studio.

Moreover, this connector regularly undergoes security and performance tests to make sure it stays ahead of the competition at all times. Extra benefits include premium support, frequent updates, and detailed documentation to help you with a quick and easy start.

• Universal access to SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Db2, and more
• Access to data sources via ADO.NET, OLE DB, and ODBC providers
• Full compliance with ADO.NET standards
• UniSQL for writing server-independent queries
• Design-time extensions and wizards
• Support for native data types, classes and structures

Core ADO.NET classes

dotConnect Universal uses a number of standard ADO.NET classes. Here is the list of those classes and brief descriptions of what they do:

• UniConnection

  Establishes a connection to a database server and initiates a transaction.

• UniCommand

  Executes SQL statements and stored procedures in a database and exposes parameters.

• UniDataReader

  Provides access to and reads a forward-only stream of data from a database.

• UniDataAdapter

  Populates a DataSet and synchronizes updates with a database.

• UniParameter

  Defines input, output, and return value parameters for commands and stored procedures.

• UniException

  Returned when a database error occurs.

• UniTransaction

  Manages database transactions.

Extra ADO.NET classes

In addition to the core classes, we have implemented a few extra ones that extend the functionality of dotConnect Universal. They are as follows:

• UniConnectionStringBuilder

  Constructs a connection string by assigning values to appropriate properties.

• UniMonitor

  Tracks dynamic SQL execution in applications that use dotConnect Universal.

• UniProvider

  Represents a custom ADO.NET data provider that can be used with dotConnect Universal.

• UniScript

  Executes a series of SQL statements separated by special symbols.

• UniCommandBuilder

  Automatically generates command properties for UniDataAdapter and populates the UniParameter collection of UniCommand objects.

Access to multiple databases with the same code

Since dotConnect Universal provides access to multiple database servers with the same code, it eliminates the need for writing conditional code for different providers or using ADO.NET interfaces directly.

• Easy connection without additional clients*
• Support for native ADO.NET providers
• Robust security with advanced encryption and authentication features
• Flexible connectivity options for diverse operational environments
• Cost-effective deployment

6.1.33 24-Feb-26

Added support for SQL Server 2025
Added support for Oracle Database 26ai
Added the LoadLicenseKey() method to the UniConnection class
Fixed an issue where the license key could not be applied on Red Hat–based Linux distributions (RHEL 9/10, AlmaLinux 9/10, Rocky Linux 9/10) when the system-wide cryptographic policy was set to DEFAULT

Additional Information