ADO.NET Provider for DB2

Build 24.0.9060

Installed Assemblies

The assemblies shipped by the provider contain standard ADO.NET components, including components for creating ASP.NET applications and SSRS reports, from code and from the designer.

Choosing the Assemblies for Your Version of the .NET Framework

The lib folder in the installation directory has .NET 4.0 assembiles. The netstandard2.0 subfolder contains the System.Data.CData.DB2 assembly compiled with .NET Standard 2.0.

Determining Project Dependencies

The following sections list the main assemblies and assemblies you need to integrate with Visual Studio designers and other tools.

Main ADO.NET Assemblies

The CData ADO.NET Provider for DB2 ships the following ADO.NET assemblies:

  • System.Data.CData.DB2.dll: This is the main ADO.NET provider assembly.
  • System.Data.CData.DB2.Designer.dll: This assembly contains design-time resources that you can include for a better development experience. It does not need to be deployed and it is not available for .NET Core applications.

Note that if you are building a .NET Core application that requires support for code pages other than UTF8 (such as Latin-1), you will need to add a NuGet reference for System.Text.Encoding.CodePages.

Entity Framework Assemblies

The provider supports Entity Framework with the following assembly:

  • System.Data.CData.DB2.Entities.EF6.dll: This assembly includes support for Entity Framework 6 (EF6).

See Using Entity Framework for information on creating Entity Framework data models with the provider.

Entity Framework Core Assemblies

The provider supports EF Core with the following assembly:

  • CData.EntityFrameworkCore.CData.DB2.dll: This assembly includes support for Entity Framework Core.

See Using Entity Framework Core for information on creating EF Core data models with the provider.

SSRS Assemblies

The provider supports SSRS 2005 and above; the assemblies for each SSRS version are located in the SSRS subfolder in the installation folder. For example:

  • CData.SSRS2017.DB2.dll: This assembly is deployed to the report server.
  • CData.SSRS2017.DB2.Design.dll: This assembly contains design-time resources that you can include for a better development experience. It does not need to be deployed.
See Using SSRS for a guide to deploying the provider to your SSRS server and creating a report.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060