Devart.Data.DB2 4.2.190

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Devart.Data.DB2 --version 4.2.190                

                    
                

            
NuGet\Install-Package Devart.Data.DB2 -Version 4.2.190
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Devart.Data.DB2" Version="4.2.190" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Devart.Data.DB2 --version 4.2.190                

                    
                

            
#r "nuget: Devart.Data.DB2, 4.2.190"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install Devart.Data.DB2 as a Cake Addin
#addin nuget:?package=Devart.Data.DB2&version=4.2.190

// Install Devart.Data.DB2 as a Cake Tool
#tool nuget:?package=Devart.Data.DB2&version=4.2.190

dotConnect for DB2

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

The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+.

More information at dotConnect for DB2.

Installation

For projects, using general ADO.NET functionality of dotConnect for DB2, you need to install the Devart.Data.DB2 package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.DB2

For projects, using Entity Framework Core 3, 5, 6, 7, 8, 9 with DB2, install the Devart.Data.DB2.EFCore package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.DB2.EF6 package.

License

dotConnect for DB2 is available in several editions. See pricing options for ordering.

To activate your license, please download dotConnect for DB2 from our website. This installer generates the trial key files required for using this package on a trial basis.

Compatibility

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

Frameworks Version support
.NET 9, 8, 7, 6, 5
.NET Core 3, 2
.NET Framework 4.8, 4.7, 4.6.2, 4.6.1

More information here

Usage

In this example, a new instance of the DB2Connection class (part of the Devart.Data.DB2 namespace) is created.

using Devart.Data.DB2;
...
DB2Connection connection = new DB2Connection();
connection.Server = "db2:50000";
connection.UserId = "db2admin";
connection.Password = "mypassword";
connection.Database = "SAMPLE";

This snippet simplifies the connection setup by directly assigning a connection string to the ConnectionString property of the DB2Connection object

db2Connection1.ConnectionString = "Server=db2:50000;UserId=db2admin;Password=mypassword;Database=SAMPLE";
ASP.NET Core and Blazor

Configuration File Snippet (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=db2:50000;UserId=db2admin;Password=mypassword;Database=SAMPLE"
   }
}

Dependency Injection of IConfiguration:

private readonly IConfiguration configuration;

public YourController(IConfiguration config) 
{
    configuration = config;
}

Retrieving a Connection String:

var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new DB2Connection(connectionString);

For more information about secure connections read at our documentation.

Key Features

  • Direct Mode: Allows your application to work with DB2 directly, without additional libraries.
  • ASP.NET Core: Supports ASP.NET Core Identity.
  • Performance: Uses many DB2-specific performance features & optimizations to ensure the highest performance.
  • Monitoring: Allows per-component tracing of database events with a free dbMonitor application.
  • Security: Supports various encryption SSL and SSH connections, etc.
  • Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Support Area

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Devart.Data.DB2:

Package Downloads
Devart.Data.DB2.EFCore

dotConnect for DB2 is a high-performance ORM enabled data provider for DB2 that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. More information at https://www.devart.com/dotconnect/db2/ License dotConnect for DB2 is available in several editions https://www.devart.com/dotconnect/db2/ordering.html To activate your license, please download dotConnect for DB2 from our website https://www.devart.com/dotconnect/db2/download.html This installer generates the trial key files required for using this package on a trial basis. Key Features * Direct Mode: Allows your application to work with DB2 directly, without additional libraries. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many DB2-specific performance features and optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
4.2.191 83 1/15/2025
4.2.190 142 12/27/2024
4.1.104 185 11/8/2024
4.1.20 216 5/30/2024
4.1.10 244 1/18/2024
4.0.0 305 11/17/2023

https://www.devart.com/dotconnect/db2/revision_history.html