IBM’s Data Server Provider for .NET Supports the Entity Framework

| by Abel Avram Follow 7 Followers on Dec 16, 2008. Estimated reading time: 1 minute |

A note to our readers: You asked so we have developed a set of features that allow you to reduce the noise: you can get email and web notifications for topics you are interested in. Learn more about our new features.

IBM has released the production version of its Data Server Provider for .NET including support for Microsoft’s Entity Framework allowing its users to create EDM schemas, and to execute EntitySQL and LINQ statements.

IBM Data Server Provider for .NET allows .NET applications to access these database management systems:

  • DB2 Database for Linux®, UNIX®, and Windows®, Version 9
  • DB2® Universal Database™ Version 8 for Windows, UNIX, and Linux-based computers
  • DB2 Universal Database Version 6 (or later) for OS/390® and z/OS®, through DB2® Connect™
  • DB2 Universal Database Version 5, Release 1 (or later) for AS/400® and System i™, through DB2 Connect
  • DB2 Universal Database Version 7.3 (or later) for VSE & VM, through DB2 Connect
  • IBM Informix® Dynamic Server, Version 11.10 or later
  • IBM UniData®, Version 7.1.11 or later
  • IBM UniVerse®, Version 10.2 or later

The provider works with the following clients:

  • IBM Data Server Client (version 9.5.3 or later)
  • IBM Data Server Runtime Client (version 9.5.3 or later)
  • IBM Data Server Driver for ODBC, CLI, and .NET (version 9.5.3 or later)

The IBM Database Add-Ins enables the creation of .NET applications for IBM’s databases in Visual Studio. The provider has some limitations when it comes to LINQ support:

  • Invocation of store specific functions is not supported.
  • Invocation of Canonical functions other than the aggregates count, sum, min, max, avg is not supported.
  • Other server specific limitations.

Useful links: DB2 and .NET FAQ. InfoQ’s ADO.NET Entity Framework news.

Rate this Article

Adoption Stage

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

iSeries and zSeries are by Steve Graegert

It's really embarrassing to see that IBM has again decided to put iSeries and zSeries on a different track. While all the other platforms and benefited from IBM's (poor) .NET efforts in the past they are doing so with this release. i/zSeries owners are forced yet again to purchase expensive DB2 Connect licenses (for proxy mode) to leverage their existing assets. No wonder that businesses consider migrating their data warehouses and BI applications to SQL Server. And so do we.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you