Universal ADO.NET Data Provider

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.

Watch the video

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
Integration with Visual Studio

The architecture of dotConnect Universal

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.