Differences between OleDB and IBM.Data DB2 connection

[ajmastrean]

Folks,

What are the differences in terms of functionality and performance
regarding connections to a DB2 database using the OleDB provider <
IBMDA400.DataSource.1 > versus an ADO.NET or IBM provided class like <
IBM.Data.DB2.iSeries >.

I am trying to avoid providing extra dll's or classes in a data access
wrapper that needs to connect to several databases (I am wrapping the
Enterprise Library 2.0 data access application block for use in various
projects).

Thanks!

 

[William \(Bill\) Vaughn]

Generally, one should avoid using OSFA (one-size-fits-all) interfaces like
OLEDB. These add extra layers of interfaces and providers that have to
translate from the generic interface to the specific provider interface and
back for each interaction with the data source. So, yes, I expect the native
managed provider should expose more functionality, be more stable and
probably quite a bit faster. However, don't believe anything I (or anyone)
says about performance. Your actual performance is often gated by issues we
don't know about.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)