IBM i Access for Windows

.NET provider

What is the .NET Data Provider?

The IBM DB2 for i .NET provider (named IBM.Data.DB2.iSeries) allows Windows applications to use the Microsoft .NET Framework to access DB2 for i databases.

What versions of .NET Framework are supported by the .NET Provider?

The 5.4 version of the .NET Provider targets the Microsoft 1.0 / 1.1 .NET Framework. For information about getting started with the 5.4 .NET provider, a handy reference is the Redbook Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET. While the 5.4 provider works with newer versions of the .NET Framework, none of the new features from the 2.0 or later Framework are available when using the 5.4 provider.

The 6.1 and 7.1 versions of the .NET Provider target the Microsoft 2.0 Framework. The 2.0 Framework provides the System.Data.Common base class model, allowing ADO.NET applications to implement provider-independent code more easily. While support for the newer Entity Framework is not provided, applications written to the 2.0 specification will run on newer .NET Framework versions without modification.

What's new?

The 7.1 .NET Provider includes these enhancements:

Where can I find more information?

The IBM DB2 for i .NET Provider Technical Reference includes a full description of the provider classes and data types, and includes usage notes on many topics. The Technical Reference is part of the IBM i Access for Windows Programmer's Toolkit, an optionally installed feature of the IBM i Access for Windows product. Be sure that you have the Programmer's Toolkit (Headers, Libraries, and Documentation) feature installed on your PC, then find a link to the Technical Reference here:

IBM i Access for Windows > Programmer's Toolkit > .NET Provider Technical Reference

What's the next step?

To ensure you get the most out of the IBM DB2 for i .NET Provider, the most recent IBM i Access for Windows service pack should be installed.

Contact IBM

  • Call IBM Support Line:
    1-800-IBM-SERV (1-800-426-7378)1-800-426-7378
    Inside the US

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

As an open innovation platform, Power Systems is optimized for big data and analytics performance and to deliver scale-out economics and security for the cloud. IBM and IBM Business Partner solutions exploit key capabilities in IBM Power Systems.

Over the last five years thousands of clients have migrated to IBM Power Systems for choice and flexibility. Learn how Power Systems has helped them revolutionise the way IT is developed and delivered, optimise for big data and analytics, and support private, public and hybrid offerings for scale-out or scale-up implementations all while improving business performance, reducing risk, and establishing a platform for growth.