Oracle-Developer.com Forums

[vj.jain]

Oracle 11g has introduced several enhancements that improve the productivity and performance of developing .NET applications.

The first series of enhancements is to enhance the development of applications using Visual Studio with Oracle 11g. First, the support for Visual Studio 2005 has been enhanced allowing the use of Oracle Developer Tools (ODT) to simplify the migration from Visual Studio 2003 to Visual Studio 2005. Many of the incompatibilities have been corrected. The visual effects and icons have been added for VS2005 as well as a number of other advancements that enhance the look and feel for .NET developers (including the support for drag and drop options). Aside from Visual enhancements, the debugging of PL/SQL code in VS2005 has been directly implemented into Visual Studio.

Native integration between ODP.NET and ADO.NET 2.0 has been provided to reduce the time required to develop .NET applications using Oracle 11g.

Several API's have been made available to Windows Developers allowing enhanced productivity. The System.Data.Common namespace has been inherited from ODP.NET to provide access through a single API to databases across multiple providers. This allows the code to be more generic and reduces the vendor specific code, promoting the easy deployment of .NET applications across multiple vendors. Also, GetSchema methods of the OracleConnection class allow the .NET code to easily discover different database schema objects.

Security has been increased with Oracle 11g by using a strongly typed connection string builder that inherits DbConnectionStringBuilder. This allows the authentication details to be sent directly from user input.

Performance has been enhanced by allowing integration of ODP.NET OracleDataAdapter batch processing for updates. For users who take advantage of the client-cache, the notification is now client based instead of table based, allowing optimal notifications of changed data when utilizing the client cache.

These and more Oracle 11g features can be found at http://www.oracle-developer.com or in the Oracle 11g New Features guide being released in March 2008 at http://www.oracle-developer.com/oracle_11g_new_features.html