Key Features of dotConnect Universal

Compatibility

Oracle

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

Microsoft SQL Server

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

MySQL

  • 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 17, 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

Platforms

  • .NET 5.0-9.0
  • .NET Core 1.x-3.0
  • .NET Standard 1.3-2.1
  • .NET Frameworks 2.0–4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)
  • .NET Compact Framework
  • Mono Framework
  • Sync Framework

OS

  • x64 and x86 architecture
  • Windows, Linux, macOS

.NET languages

  • C#
  • VB.NET
  • F#

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

Script execution

  • 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

SQL execution monitoring

  • 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

Security standards

  • SSL/TLS, SSH connections
  • Connection through proxy servers and HTTP tunnels
  • Connected and disconnected data access models
  • Support for the compression protocol
  • Unicode connections
  • Failover support
  • Load balancing support
  • Encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
  • Checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
  • Operation in the FIPS 140-2 mode in Windows

Certification

  • DigiCert Trusted G4 Code Signing RSA4096 SHA384 2021 CA1

Data access features

  • Intelligent fetch block size control
  • Advanced connection pooling
  • High-performance batch processing
  • Native Library Pre-Loading

IDE integration

Visual Studio

Microsoft Visual Studio

  • Microsoft Visual Studio 2022, 2019, 2017, 2015, 2013, 2012, 2010, 2008
  • DataSet Wizard to create and edit typed datasets
  • DataSet Manager to list and bind datasets in the project
  • DataSet Editor to edit dataset contents
  • Advanced design-time component and property editors
  • IntelliSense descriptions for classes
  • Syntax highlighting in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management in design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • CodeGear Delphi 2007
  • Embarcadero Delphi Prism
  • Support for the Enterprise Library Data Access Application Block (DAAB)

NuGet availability

Devart.Data.Universal 
dotnet add package Devart.Data.Universal
Devart.Data.Universal.Oracle 
dotnet add package Devart.Data.Universal.Oracle
Devart.Data.Universal.MySql 
dotnet add package Devart.Data.Universal.MySql
Devart.Data.Universal.SqlServer 
dotnet add package Devart.Data.Universal.SqlServer
Devart.Data.Universal.PostgreSql 
dotnet add package Devart.Data.Universal.PostgreSql
Devart.Data.Universal.SQLite 
dotnet add package Devart.Data.Universal.SQLite
Devart.Data.Universal.DB2 
dotnet add package Devart.Data.Universal.DB2
Devart.Data.Universal.Firebird 
dotnet add package Devart.Data.Universal.Firebird
Devart.Data.Universal.OleDb 
dotnet add package Devart.Data.Universal.OleDb
Devart.Data.Universal.Odbc 
dotnet add package Devart.Data.Universal.Odbc