dotConnect for DB2

Connect DB2 Data With .NET Application Easily

dotConnect for DB2 is an enhanced ORM enabled data provider for DB2 that builds on ADO.NET technology and IBM DB2 .NET Data Provider to present a complete solution for developing DB2-based database applications. It allows you to easily integrate DB2 data with widely used data-oriented technologies and use them in your .NET applications. It offers better Entity Framework support, more features for ASP.NET projects, native SSIS Source and Destination components and many more.

Features

Full support of the latest versions of DB2
Full support for x64 architecture
Full support for ADO.NET Entity Framework v1 - v6
Entity Framework Core support
Full CRUD (Create, Retrieve, Update, Delete) support
High performance

Full list of features

Compatibility

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

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

To establish a connection to server you have to provide some connection parameters to dotConnect for DB2. This information is used by the DB2Connection component to find the server and login with credentials of your account. The parameters are represented as connection string. You can compose the connection string manually or have dotConnect for DB2 construct it for you.

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

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

Read the full documentation for connection here.

Advanced ADO.NET Provider

dotConnect for DB2 offers a number of innovative development tools and technologies, not available in IBM DB2 .NET Data Provider. It supports both connected (DataTable) and disconnected (DataSet) models of data access, provides advanced components, such as DB2Script, powerful tools - DataSet Wizard and DataSetManager, etc.

Entity Framework Support

dotConnect for DB2 allows you to access DB2 data via Entity Framework - Microsoft's recommended data access technology. It supports Entity Framework and Entity Framework Core, and enables you to use the following Entity Framework features with DB2 data:

LINQ to Entities (no need for DB2 API)
Entity relations with lazy/eager loading
No need to post each edited/created object separately - a single SaveChanges() call to persist all the changed objects

dotConnect for DB2 provides enhanced Entity Framework support for DB2 data with a bundled visual designer for ORM models with Visual Studio integration - Entity Developer. Standard Visual Studio Entity Data Model designer is also supported.

ASP.NET Support

dotConnect for DB2 provides a number of features for ASP.NET projects. It provides an advanced DB2DataSource component for data access and ASP.NET provider model support. It offers such ASP.NET providers as Membership provider and role provider (along with SimpleMembership providers), Session State provider, Site Map provider, Web Event provider, and Personalization provider.

License

See pricing options for ordering.

Trial Limitations

The dotConnect for DB2 Evaluation License lets you try dotConnect for DB2 Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Support Area

Documentation Request form Feedback page Product history

Devart Software