Microsoft Kills Its Oracle Data Provider for ADO.NET -- Visual Studio Magazine

Microsoft Kills Its Oracle Data Provider for ADO.NET

By Jeffrey Schwartz
06/16/2009

In a significant move for those who develop .NET applications targeting Oracle databases, Microsoft is removing the Oracle data provider from its ADO.NET roadmap.

Microsoft said yesterday it decided discontinue its System.Data.OracleClient because a significant percentage of its MVPs tend to use alternative third-party offerings. Himanshu Vasishth, the company's program manager for the ADO.NET OracleClient, made the announcement in a posting on the ADO.NET team blog.

Microsoft will still make System.Data.OracleClient available in .NET Framework 4, but it will be labeled as "deprecated," according to Vasishth. "This will have no impact to existing applications and these applications will continue to work as expected," Vasishth noted.

"Developing new applications which use OracleClient will be supported; however, warnings will be raised if the applications are compiled against .NET 4. Once compiled, no warnings or errors will be generated while running these applications. We strongly recommend customers to use our partners' ADO.NET Provider for Oracle instead of continuing to use Microsoft's OracleClient for new application development," he wrote.

Among those who offer such providers are DataDirect Technologies and Devart (formerly known as Core Lab). In addition, Oracle's provider, called Oracle Data Provider for .NET (ODP.NET), is a popular and viable option, said Andrew Brust, chief of new technology at twentysix New York.

"Oracle's own support for ADO.NET and Visual Studio itself has been generally quite good," Brust said in an e-mail interview. "There is a dedicated .NET team at Oracle, and they are good at what they do and quite apolitical."

Microsoft MVP Benjamin Day of Benjamin Day Consulting Inc. said Microsoft's decision makes sense. "Why should Microsoft bend over backwards to support connections to a competitor's database, especially if they have market research data points that say Microsoft customers lean toward Oracle's implementation rather than Microsoft's implementation?" Day said in an e-mail.

This also frees Microsoft from having to support .NET-to-Oracle versioning or performance issues, Day added.

Microsoft will continue to offer bug fixes and other critical updates in line with its support policy for the .NET Framework 4, according to Vasishth.

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.