dotConnect for DB2

Connect DB2 Data With .NET Application Easily

Get Started | Explore Features | Documentation

30 days free trial • ORM support • Visual Studio integration

dotConnect for DB2 is a versatile enterprise-grade connector that enables access to Db2 data in .NET applications of all levels. It delivers advanced ORM support, compatibility with multiple Db2 versions and .NET platforms, and easy integration with a variety of IDEs, including 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.

ORM support: EF Core, Dapper, NHibernate, LinqConnect, etc.
Full compliance with ADO.NET standards
Secure SSL/SSH connections, proxy servers, and HTTP tunneling
Advanced encryption and data integrity
Support for Db2-specific features and data types
Integration with Visual Studio and design-time support

Installation

Install the NuGet Package

Install-Package Devart.Data.DB2

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

Activate license

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

Usage

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

using Devart.Data.DB2;

namespace DB2ConnectionExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "" +
                "User Id=TestUser;" +
                "Password=TestPassword;" +
                "Server=127.0.0.1;" +
                "Database=TestDatabase;" +
                "current schema=TestSchema;" +
                "License Key=**********";

            using (DB2Connection connection = new DB2Connection(connectionString))
            {
                try
                {
                    connection.Open();
                    Console.WriteLine("Connection successful!");
                }
                catch (DB2Exception ex)
                {
                    Console.WriteLine($"Error: {ex.Message}");
                }
            }
        }
    }
}

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
Entity Framework Core	10, 9, 8, 7, 6, 5, 3, 2, 1
.NET	10, 9, 8, 7, 6, 5
.NET Core	3.1, 2
.NET Framework	4.8-2.0

More information here

Enhanced ORM Support

dotConnect for DB2 offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our DB2 ADO.NET Provider supports the following ORMs:

Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
NHibernate 1.x-5.x
Dapper 1.x, 2.x

Advanced Visual Studio Integration with DB2

dotConnect for DB2 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.

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

Support Area

Devart Software