Key Features of dotConnect Universal

Compatibility

Oracle

• Servers 26ai, 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, and 8.0, including Personal and Express editions.
• Clients: 26ai, 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, and 8.0.

Microsoft SQL Server

• SQL Azure, SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 (including Express editions), SQL Server 2000 and MSDE.

MySQL

• 26.x, 9.x, 8.4, 8.0, 5.7, 5.6, 5.5, 5.4, 5.1, 5.0, 4.1, 4.0, and 3.23, including Embedded servers (starting with 4.1), 64-bit MySQL servers, Percona, and MariaDB.
• Amazon RDS for MySQL, Amazon RDS for MariaDB (versions 5, 10, 11), and Amazon RDS for Aurora.

PostgreSQL

• Versions 8 through 18, as well as EnterpriseDB, Pervasive PostgreSQL servers, and Heroku Postgres.

SQLite

• Version 3 and later.

DB2

• DB2 for LUW: Version 8.0 and later.
• DB2 for OS/390 and z/OS via DB2 Connect: Version 6 and later.

Microsoft Access

• Version 2021, 2019, 2016, 2013, 2010, 2003, 2000, 97, 95.

InterBase

• Versions 6.x and later.
• Firebird: Versions 2.x, 1.x.
• Yaffil

Core ADO.NET classes

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

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.

Key features

• UniSQL for writing server-independent queries
• Provider-specific types infrastructure
• Fill the DataSet with several CURSORs for Oracle Database
• Asynchronous execution support
• DataSet Wizard for design-time setup
• Generate DataSet Wizard
• Support for Data Access Application Block in Enterprise Library
• ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
• Base-Class-Based provider model
• Advanced connection pooling
• Ability to retrieve metadata information
• Easy migration from SQL Server, OLE DB, ODBC, and Oracle Data Providers with the Migration Wizard
• Advanced script execution features with the UniScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Extended SQL tracing capabilities with the UniMonitor component
• Support for the dbMonitor utility for advanced tracing analysis and control
• Per-component SQL tracing
• Optional log output to IDE tool windows
• Array Binding support
• Batch execution optimizations
• Support for the Enterprise Library Data Access Application Block (DAAB)
• Sync Framework

NuGet availability

dotnet add package Devart.Data.Universal

dotnet add package Devart.Data.Universal.Oracle

dotnet add package Devart.Data.Universal.MySql

dotnet add package Devart.Data.Universal.SqlServer

dotnet add package Devart.Data.Universal.PostgreSql

dotnet add package Devart.Data.Universal.SQLite

dotnet add package Devart.Data.Universal.DB2

dotnet add package Devart.Data.Universal.Firebird

dotnet add package Devart.Data.Universal.OleDb

dotnet add package Devart.Data.Universal.Odbc