Oracle's 11g Database to Feature Major .NET Hooks -- Visual Studio Magazine

Oracle's 11g Database to Feature Major .NET Hooks

Long-awaited next version of Oracle Corp.’s database will feature significant .NET-related improvements.

By Jeffrey Schwartz
08/01/2007

While Oracle Corp. is set to ship its next-generation database server this month for Linux, the Windows version is not far behind and will offer significant improvements for .NET developers.

The Oracle 11g database boasts 400 new features in all, promising substantial improvements in performance, storage management and integration with .NET, Java and PHP-based tools, Oracle President Charles Phillips told attendees at the launch event last month.

While Microsoft and Oracle are competing fiercely for share at the database platform level, the companies have a three-year-old partnership intended to ease development for Windows and .NET developers programming to Oracle databases. On that front, Oracle 11g is said to raise the bar over 10g, the three-year-old version it replaces.

"We want to expose all of the Oracle database features from .NET and help developers become as productive as possible," says Christian Shay, Oracle's principal product manager for .NET and Windows.

Francois Ajenstat, director of product management for Microsoft's SQL Server, welcomes Oracle's support for Visual Studio but argues the vendor is playing catch-up. Microsoft already offers integration of Visual Studio with SQL Server.

Microsoft has its own major upgrade to SQL Server 2005 in the works, dubbed SQL Server 2008. A commercial release is not expected until the second quarter of 2008, Ajenstat says.

As for 11g, the improved Visual Studio integration includes an upgrade to the company's free SQL Developer tool. The tool's existing proprietary PL/SQL language editor will have a full debugger. For .NET developers, that debugger can be integrated into Microsoft's Visual Studio as well, Shay says.

Another new feature in the SQL Developer tool is a migration utility that was previously a separate client-based application. Oracle is also packaging SQL Developer with the 11g database. SQL Developer was originally released last year as a downloadable add-on to 10g. Integrating it into the 11g package will likely prompt broader usage, says David Gambino, Oracle's director of product management.

Also packaged with the new database are a migration utility and Oracle's SQL Developer Tool, Oracle Application Express 3.0 and an updated version of Oracle Data Access Components, or ODAC. Included in the new ODAC release is Oracle Data Provider for .NET and an ADO.NET 2.0-compliant data access provider. ODAC also includes the Oracle Developer Tools for Visual Studio.NET.

About the Author

Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.

Printable Format

comments powered by Disqus

Featured

Compare New GitHub Copilot Free Plan for Visual Studio/VS Code to Paid Plans

The free plan restricts the number of completions, chat requests and access to AI models, being suitable for occasional users and small projects.
Diving Deep into .NET MAUI

Ever since someone figured out that fiddling bits results in source code, developers have sought one codebase for all types of apps on all platforms, with Microsoft's latest attempt to further that effort being .NET MAUI.
Copilot AI Boosts Abound in New VS Code v1.96

Microsoft improved on its new "Copilot Edit" functionality in the latest release of Visual Studio Code, v1.96, its open-source based code editor that has become the most popular in the world according to many surveys.
AdaBoost Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the AdaBoost.R2 algorithm for regression problems (where the goal is to predict a single numeric value). The implementation follows the original source research paper closely, so you can use it as a guide for customization for specific scenarios.
Versioning and Documenting ASP.NET Core Services

Building an API with ASP.NET Core is only half the job. If your API is going to live more than one release cycle, you're going to need to version it. If you have other people building clients for it, you're going to need to document it.