Devart.Data.DB2 5.1.100

Advanced C# Connection Provider for DB2

dotConnect for DB2 is a high-performance ORM enabled data provider for IBM DB2 that builds on ADO.NET technology.

The provider works with .NET Frameworks, .NET Core, .NET.

It supports a wide range of DB2-specific features, such as secure SSL and SSH connections, proxy server support, HTTP tunneling, full support for DB2-specific data types, and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.

More information at dotConnect for DB2.

Installation

1. Install the NuGet Package

Install-Package Devart.Data.DB2

2. 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

Work with EF Core and Entity Framework

For projects, using Entity Framework Core with DB2, install the Devart.Data.DB2.EFCore package.

Compatibility

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

More information here

Key Features

• High Performance Data Access: Built-in DB2-specific optimizations, efficient connection pooling, background data fetching, and pagination with selective loading ensure low-latency access for high-throughput applications.
• Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
• DB2 Data Type Support: Full native support for DB2-specific data types and commands ensures accurate operation across all major IBM DB2 versions.
• Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, supporting everything from legacy enterprise systems to modern cloud-native applications.
• Disconnected Data Management: Manage relational data offline using DB2DataSet and DB2DataTable, with support for batch updates, UI data binding, and local data manipulation.
• Real-Time Monitoring: Track database operations using the dbMonitor utility for per-component tracing of DB2 database events.
• Visual Studio Integration: Accelerate development with wizards for connection setup, typed DataSet generation, and schema management—all embedded in Visual Studio.
• Reliable Bulk Operations: Efficient bulk data import and export support for large-scale data migrations and ETL workflows.
• Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.

Usage

To help you get started quickly, here's a simple code example demonstrating how to connect to a DB2 database.

using Devart.Data.DB2;

class Program
{
  static void Main()
  {
    string connectionString = "" +
      "Server=127.0.0.1;" +
      "User Id=TestUser;" +
      "Password=TestPassword;" +
      "Database=TestDatabase;" +
      "Current Schema=TestSchema;" +
      "License Key=**********";

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

Basic Connection Strings

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Related Packages

• Devart.Data.DB2.EFCore

Support Area

• Documentation
• Request form
• Feedback page
• Product history