Oracle Data Provider for .NET
Oracle Data Provider for .NET
The following enhancements have been made to Oracle Data Provider for .NET after Oracle Database 10g release 2 (10.2):- Performance Enhancements for Oracle Database 11g Release 1 (11.1)
The following performance enhancements have been made:
ODP.NET Configuration
Developers can configure ODP.NET using configuration files, including the application config, web.config
, or machine.config
files. Settings in the machine.config
file override the registry settings. The settings in the application config or the web.config
file override the values in the machine.config.
- Improved Parameter Context Caching
This release enhances the existing caching infrastructure to cache ODP.NET parameter contexts. This enhancement is independent of database version and it is available for all the supported database versions. This feature provides significant performance improvement for the applications that execute the same statement repeatedly.
This enhancement is transparent to the developer. No code changes are needed to use this feature.
- Efficient LOB Retrieval With SecureFiles
This release improves the performance of small-sized LOB retrieval by reducing the number of round-trips to the database. This enhancement is available only with Oracle 11g Release 1.0 or later database versions.
This enhancement is transparent to the developer. No code changes are needed to use this feature.
- The following enhancements have been made to 10.2.0.3:
- Starting 10.2.0.3, ODP.NET natively supports the 64-bit .NET Framework for the following 64-bit Windows platforms:
- Windows x64 for AMD64 and Intel EM64T processors
- 64-bit Windows for Intel Itanium
- Starting 10.2.0.3, ODP.NET natively supports the 64-bit .NET Framework for the following 64-bit Windows platforms:
64-bit systems enables more scalable and better performing ODP.NET applications.
- Configuring
FetchSize
through the Windows registry is added to ODP.NET 10.2.0.3. This feature enables applications to specify the default result set fetch size through the registry. - Local Transaction Support for
System.Transactions
feature is added to ODP.NET 10.2.0.3. This feature enablesSystem.Transactions
to use local transactions rather than distributed transactions. This can be specified either through the registry or through a connection string attribute. - Support for Microsoft ADO.NET 2.0 is added to ODP.NET release 10.2.0.2 and includes the following:
- Provider Factory Classes and Base Classes
Simplifies data access code to access multiple data sources with a provider generic API.
- Connection String Builder
Makes creating connections strings less error-prone and easier to manage.
- Data Source Enumerator
Enables the application to generically obtain a collection of the Oracle data sources that the application can connect to.
- Support for Schema Discovery
Permits application developers to find and return database schema information, such as tables, columns, and stored procedures.
System.Transactions
Support
ODP.NET supports implicit and explicit transactions using the System.Transactions
namespace models.
- Batch Processing Support
Enables batch processing when the OracleDataAdapter
.Update method is called.
|