BT

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

by Abel Avram on Dec 16, 2008 |

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.

Hello stranger!

You need to Register an InfoQ account or 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

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT