dotConnect Universal

Universal .NET Connector for Major Databases

Get Started | Explore Features | Documentation

30 days free trial • Visual Studio integration

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

Installation

Install the NuGet Package

Install-Package Devart.Data.Universal.SqlServer

Or download the Windows installer (.exe) from the official website.

Activate license

Free Trial License: Evaluate the full capabilities of dotConnect Universal in a non-commercial environment—ideal for development and testing. Start your free trial
Commercial License: Deploy dotConnect Universal in commercial applications and access full technical support with a valid license. Purchase a license

Usage

This snippet directly configures a Universal connection using a connection string.

using Devart.Data.Universal;

string connectionString =
    "Provider=SQL Server;" +
    "Data Source=SERVER;" +
    "Initial Catalog=Northwind;" +
    "User ID=TestUser;" +
    "License Key=**********";

using var connection = new UniConnection(connectionString);

try
{
    connection.Open();

    using var command = connection.CreateCommand();
    command.CommandText = "SELECT actor_id, first_name, last_name FROM actor";
    using var reader = command.ExecuteReader();

    Console.WriteLine("Actors:");
    while (reader.Read())
    {
        var id = reader.GetInt32(0);
        var firstName = reader.GetString(1);
        var lastName = reader.GetString(2);
        Console.WriteLine($"{id}: {firstName} {lastName}");
    }
}
catch (Exception ex)
{
    Console.WriteLine("Error while connecting or executing query:");
    Console.WriteLine(ex.Message);
    Environment.ExitCode = 1;
}
finally
{
    if (connection.State != System.Data.ConnectionState.Closed)
    {
        connection.Close();
    }
}

Read the full documentation for connection here.

Video overview

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks	Version support
.NET	10, 9, 8, 7, 6, 5
.NET Core	3.1, 2
.NET Framework	4.8-2.0

More information here

Advanced Visual Studio Integration

dotConnect Universal provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

Universal ADO.NET Provider supports advanced Visual Studio integration (DDEX) and provides convenient visual component editors to simplify component tweaking.

Support Area

Devart Software