Microsoft Kills Its Oracle Data Provider for ADO.NET

[SQLDenis]

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.

http://reddevnews.com/Articles/2009/06/ ... DONET.aspx

Of course you can just use the provider that Oracle makes

Oracle Data Provider for .NET
The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. The data provider can be used with the latest .NET Framework 3.5 version.
ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from other .NET drivers, including a native XML data type, array parameters, RAC optimizations, and statement caching. ODP.NET is designed for scalable enterprise Windows solutions by providing full support for Unicode and local and distributed transactions. Distributed transactions are supported using the Oracle Services for MTS.

http://www.oracle.com/technology/tech/w ... index.html

[jonbruce]

Connect for ADO.NET from DataDirect Technologies offers a client-less solution for .NET platforms –free from OracleClient or so called Instant Client . Go grab a copy of our install to check out what a true pedigree, 100% managed provider can offer while supporting the latest .NET technologies such as the ADO.NET Entity Framework provider for Oracle –

http://www.datadirect.com/downloads/mai ... NLDCADONET

[chrissie1]

I actualy use your product jon and I'm very happy with it

[riverguy]

chrissie1, do you use the Oracle provider Jon has referenced? Sounds interesting as ODAC providers are a pain.

[chrissie1]

yes I use this.

http://www.datadirect.com/products/net/ ... NLDCADONET

a lot eassier to setup too no need for drivers on the clients.