Databases Reference
In-Depth Information
.NET data provider
The .NET developers have choices of incorporating ODBC .NET Data provider,
OLE DB .NET Data provider, or DB2 .NET Data provider (native provider). We
recommend that you first consider DB2 .NET Data provider when it comes to
.NET Application development. There are a number of enhancements made in
DB2 .NET Data provider in V9 for native XML support:
The ODBC .NET Data provider makes ODBC calls to DB2 data source using
DB2 CLI driver. It has same keyword support and restrictions as that of DB2
CLI driver and can be used only with .NET Framework Version 1.1 or Version
2.0. This utilizes IBM DB2 ODBC (thus CLI) driver.
The OLE DB .NET Data provider uses IBM DB2 OLE DB Driver (IBMDADB2).
It has same keyword support and restrictions as that of DB2 OLE DB driver
and can be used only with .NET Framework Version 1.1 or Version 2.0. This
utilizes IBM DB2 OLE DB (IBMDADB2) driver.
The DB2 .NET Data provider extends DB2 support for the ADO.NET
interface. The DB2 managed provider implements the same set of standard
ADO.NET classes and methods and it is defined under IBM.DATA.DB2
namespace. We will use DB2 .NET Data provider for the sample application
example in Chapter 6, “Application development with .NET” on page 251.
1.2 DB2 Express-C
DB2 Express-C
is a version of DB2 Universal Database Express Edition (DB2
Express) for the community, which is completely free to download, develop,
deploy, test, run, embed and redistribute. It provides the same core data server
features and development interfaces as well as system limits as DB2 Express in
a smaller package. DB2 Express-C is available for Linux and Windows running
32-bit or 64-bit hardware with up to 2 CPUs and 4 GBs of memory.
Support for DB2 Express-C is made available through forum:
DB2 Express-C can be seamlessly upgraded to DB2 Express, Workgroup, and
Enterprise Server Edition without database or application modification.
DB2 Express-C is free to download from:
Search WWH ::
Custom Search