Overview
ADO.NET is the data access component for the .NET Framework. ADO.NET is made of a set of classes that are used for connecting to a database and providing access to relational, XML or application data. Progress DataDirect offers the only 100% managed code ADO.NET data providers for all major databases. By using 100% managed code, you can take advantage of the numerous built-in services of the CLR and enhance the performance of your managed application.
- Directly connect to Db2 in a fully managed driver that is a 100% .NET code
- Protects data in motion with no direct access to memory or machine registers
- Integrate Db2 without client libraries across all versions
Features
Security
Limit security vulnerabilities with our fully managed ADO.NET providers and broad support for enterprise authentication and encryption methods.
Performance
Improve data access performance by simply switching ADO.NET providers, without changing application code
Reliable
Ensure high availability via application failover and workload balancing without costly server configurations
Extensive
Certified DataDirect quality guarantees ADO.NET connectivity across all supported database versions and distributions with complete functionality
Codeless Configuration
Optimize your application performance and compatibility without any changes to the code
Speed
Easily load large volumes of data without application code or additional vendor tools that slow performance
Technical Specifications
Progress DataDirect Connect for ADO.NET Entity Framework
Version 4.3.0
- DB2 ADO.NET Entity Framework requires .NET Framework 4.5 and later versions
- DB2 ADO.NET Entity Framework supports features of Entity Framework 6.0
- DB2 Entity Framework data providers now require Entity Framework 6.0.
Database Support
- DB2 UDB V7R3 for i
- DB2 UDB V7R2 for i
- DB2 UDB V7R1 for i
- DB2 UDB V6R1 for i
Programming Support
- Applications Targeting .NET Framework 4.5
- Database First, Model First, Code First, DBContext, Code First Migrations, Enumerated Types, Table Valued Functions, Code-Based Configuration (EF 6.0), Multiple Context Support, Connection Resiliency, Code First Map DML Operations To Stored Procedures
DataDirect Connect for ADO.NET version 4.3 has been certified for running on the .NET Framework Versions 2.0 SP1 or higher, 3.5 SP1, 4.0, 4.5, 4.6 and 4.7
Progress DataDirect Connect for ADO.Net
Version 4.3.0
- Machine must have .NET Framework 4.0 or higher with the .NET Framework Redistributable Version 4.0 or higher installed
- DataDirect Connect for ADO.NET version 4.3 has been certified for running on the .NET Framework Versions 2.0 SP1 or higher, 3.5 SP1, 4.0, 4.5, 4.6 and 4.7
- The data providers connect to the following database on all platforms supported by the database vendor, unless otherwise noted. Both 32-bit and 64-bit versions are supported. In addition, all editions and service packs/fix packs of the database version are supported.
- Visual Studio 2017 and 2019
Database Support
- DB2 V10 and V11 for Linux, UNIX, Windows using DRDA
- DB2 V9.1, V9.5, V9.7 for Linux, UNIX, Windows
- DB2 V8.x for Linux, UNIX, Windows
- DB2 UDB V7.x for Linux, UNIX, Windows
- DB2 V12 for z/OS
- DB2 V11 for z/OS
- DB2 V10.1 for z/OS
- DB2 V9.1 for z/OS
- DB2 UDB V8.1 for z/OS
- DB2 UDB V7R1, V7R2, V7R3 for i
- DB2 UDB V6R1 for i
Documentation
Progress DataDirect for ADO.NET