VistaDB.Net Logo

Microsoft deprecating Oracle Client from ADO.NET 4

by Jason Short 16 June 2009

Microsoft has announced through a blog that the ADO.NET 4 spec will mark the Oracle client as deprecated with plans for removal.  They are also recommending that users go to a third party Oracle provider.

Visual Studio Magazine has picked up the story now as well.

Stop Helping the Competition?

Wow, this will mark the first time an ADO.NET provider has been removed from the .Net framework.  Is this a case of Microsoft trimming the fat, or pushing Oracle?  I always thought it a bit of a free ride that Microsoft was helping Oracle by building their provider for them, but no one else got such special treatment. 

And equally as strange to me was that Oracle was built in, when no other third party could get their provider included.  I guess they are going to make that equal across the board, no one else gets included.

Another reason to stay managed code!

This is yet another reason to stay with fully managed code as well.  You won’t have provider install issues that these guys are going to have going forward.  Oracle client users are now going to have to install a provider that probably will not be 100% managed code.  That is going to mean two or more distributions (32 / 64 bit), and probably issues with medium trust support.

VistaDB of course is 100% managed code and has no such issues.  Since we can deploy a single assembly to both 32 and 64 bit machines we get around the entire install issue.  And since we are 100% managed code with no DllImports you never have a trust issue with the admin settings on the box.

Oracle = Large?

This is going to affect a lot of Oracle developers eventually.  But since most Oracle shops are pretty large companies maybe it is not such a big deal anyway.  Larger companies take a long time to migrate from one platform to the next.  Let’s fact it, .Net 4 might be 10 years away for them anyway.  Some of them just made the move to .Net 2.

Any smaller shops using Oracle?  I honestly don’t know any, but we walk mostly in SQL Server circles.

Comments

16 June 2009 #

trackback

Microsoft deprecating Oracle client in Dot Net 4

You've been kicked (a good thing) - Trackback from DotNetKicks.com

DotNetKicks.com

16 June 2009 #

Chris Pietschmann

If you're using Oracle with a .NET application this is something to be aware of, but nothing to really worry about. If you have an existing business app running on .NET 2.0 or 3.5, then you may not have much need to upgrade to a newer version of the framework for quite some time, and frankly there's not much reason to.

Also, just because it's marked as Deprecated doesn't mean you can use it. All this means is that it will be removed in some future version of the framework, but I would guess that wont be for some time. Since both .NET 3.0 and 3.5 run on top of .NET 2.0, I would suspect that a couple "versions" of .NET will also run on top of .NET 4.0 in the same way; possibly 4.5, 5.0 or even 6.0?.

Plus, I really don't know of all that many .NET apps that use Oracle. Most apps are using SQL Server, and some smaller ones just use XML files to store data. Really this could just be Microsoft not really wanting to spend more money adding support for newer versions of Oracle.

Chris Pietschmann United States

16 June 2009 #

js_vistadb

"Deprecated does not mean you can't use it" is a true statement.  But are you going to base your code on something that is basically flagged as "Good luck"?  To me deprecated means run away quickly and migrate to something else before it bites you in the buttocks.

"I really don't know of all that many .NET apps that use Oracle" - Maybe that is the real crux here.  Maybe Microsoft is tired of supporting Oracle users when Oracle doesn't seem to care about .Net.

js_vistadb United States

17 June 2009 #

James Avery

Actually this is a good thing. Their driver was horrible and Oracle provides an ADO.NET driver that is faster and better in every way.

James Avery United States

17 June 2009 #

js_vistadb

If the Oracle provider is better and faster then why are there two different third parties that offer drivers for Oracle?  I have never understood why there were these third party versions.  I assumed that it was because Oracle didn't provide a very good driver.

js_vistadb United States

17 June 2009 #

James Avery

The Oracle version of the driver was pretty late to the game, I think this is why Microsoft provided a driver and probably the reason for the 3rd party drivers. The other possible reason is that the Oracle version only works with Oracle 9i and above, so anyone with an Oracle 8 db would need to buy a third party or use the MS one.

James Avery United States

17 June 2009 #

Jim

The Oracle Data Provider for .NET (ODP.NET) has been around for a few years. Its fully managed code that is more optimized and a bit faster than the ADO.NET Oracle client. Any .NET developer that is using Oracle should already be using the ODP.NET.

If Oracle is already providing a better product and .NET developers who use Oracle are already using ODP.NET, then having the ADO.NET Oracle client is just something that nobody will be using.

I've been using the ODP.NET provider for years in .NET apps.  

Jim United States

17 June 2009 #

Waxer

I agree with James A. This is a good thing for Oracle/.NET developers. The MS driver was horrid. Oracle's own ADO.NET driver is actually pretty good now. Why MS even offered a driver in the first place is a good question though (perhaps to make migration to SQL Server easier?). It is clearly no longer necessary. Same for 3rd party drivers. My guess is the 3rd parties were quicker to get a commercial driver to market than Oracle, but now Oracle has caught up. Oracle does care about .NET, else they risk loosing market share to SQL Server.

Waxer United Kingdom

17 June 2009 #

Iwan Arif

I agree with James Avery, there's no point MS supporting the oracle driver, since oracle have their own native driver which upgraded linearly to their DB version.

Iwan Arif United States

17 June 2009 #

Jeffrey Becker

What I remember of the built-in Oracle provider was that it was very buggy.  IIRC it spoke Oracle 7's protocol when Oracle 10g was the new thing.  You couldn't call certain types of procedures with it etc.  But as everyone else has said, who's using .Net that really uses Oracle?  I would think that Java is a better fit for an Oracle shop.

Jeffrey Becker United States

18 June 2009 #

runxc1(Bret Ferrier)

I think that this is horrible.  I hate installing the Oracle Client and have run into a good number of errors with the Oracle ODP.NET driver and 64 bit servers which problem does not exist with the .Net Oracle Driver.  I reeeaaallly don't want to change to Providers but maybe Oracle will fix their driver/64bit issues by time .Net 4.0 comes out but then again Oracle now owns Java so probably not.

runxc1(Bret Ferrier) United States

20 June 2009 #

IISMATT

What's next, the DB2 provider or is that already gone too?

IISMATT United States

21 June 2009 #

Iwan Arif

I think oracle will always support .net platform. see, oracle only want to sell their DB, not the platform. Oracle can't cashed in with their Java Platform.

And to me personally java and .net was not that significantly better than the other.

I see much stronger support coming from oracle to hugs .net technology, which is a good thing for everybody Smile.

Iwan Arif U.A.E.

23 June 2009 #

Jonathan Bruce

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/main-registration-form/verify/index.ssp?&atc=DDWBDNLDCADONET

Jonathan Bruce United States

Comments are closed

Powered by BlogEngine.NET and VistaDB

Log in