1) the following chart represents the difference of duration for different data provider with three different row count, The ODP.net take the shortest time, and BDP.net take the longest time.
2) All of three providers are based on ADO.NET, this means they have same basic classes and methods,
If we are going to replace MSDP.NET with ODP.NET, what we need to do is changing the library reference and the units in uses section,
But they also have some slightly difference, for instance, the oracle data type for ref cursor in MSDP is OracleType.cursor, and
the oracle data type for ref cursor in ODP is OracleDBType.RefCursor
3) All of three providers support Ref Cursors returned by Oracle stored proc
4) Both of MS data provider and Oracle data provider support database connection pooling, but Borland Data Provider doesn't support it
5) MS data provider offers an OracleLob object that handles all Oracle LOB database objects in the same fashion, while the Oracle data provide offers
specific objects for both Oracle BLOB and CLOB database objects. This means ODP.NET provides better support for these Oracle datatypes.
For instance, the OracleClob object overrides the read method to populate a char array. This feature is especially useful when dealing
with Unicode and other multibyte characters.
6) The MS data provider come with DotNet framework, and the DotNet framework is part of in windows XP professional and windows 2003 server .
whereas Oracle data provider or Borland Data Provider need to be installed separately
