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

Hands On: New VS Code Insiders Build Creates Web Page from Image in Seconds

New Vision support with GitHub Copilot in the latest Visual Studio Code Insiders build takes a user-supplied mockup image and creates a web page from it in seconds, handling all the HTML and CSS.
Naive Bayes Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the naive Bayes regression technique, where the goal is to predict a single numeric value. Compared to other machine learning regression techniques, naive Bayes regression is usually less accurate, but is simple, easy to implement and customize, works on both large and small datasets, is highly interpretable, and doesn't require tuning any hyperparameters.
VS Code Copilot Previews New GPT-4o AI Code Completion Model

The 4o upgrade includes additional training on more than 275,000 high-quality public repositories in over 30 popular programming languages, said Microsoft-owned GitHub, which created the original "AI pair programmer" years ago.
Microsoft's Rust Embrace Continues with Azure SDK Beta

"Rust's strong type system and ownership model help prevent common programming errors such as null pointer dereferencing and buffer overflows, leading to more secure and stable code."
Xcode IDE from Microsoft Archrival Apple Gets Copilot AI

Just after expanding the reach of its Copilot AI coding assistant to the open-source Eclipse IDE, Microsoft showcased how it's going even further, providing details about a preview version for the Xcode IDE from archrival Apple.