If you recall starting .NET 1.1 until .NET 3.5 all the .NET platform shipped with an assembly named System.Data.OracleClient.dll, which was one of the recommended data provider to connect .NET appplication with Oracle databas.seas the name suggests, offered a data provider to communicate with Oracle databases.
With the release of 4.0, Microsoft made this assembly obsolete and will eventually be deprecated.
The reason is certainly not that Microsoft only wants SQL Server and other MS specific Dbs to be used using .NET, but the actual reason is that Oracle corp provides its own custom .NET assembly, which follows the same overall design guidelines as the data providers provided by Microsoft.
You can download this assembly free of cost from Oracle corp’s web site at
www.oracle.com/technology/tech/windows/odpnet/index.html.
I am a hands-on architect with proven 19+ years of experience in architecting, designing, and developing distributed software solutions for large enterprises. At Microsoft, as a Principal Software Engineering Manager, I own the Platform team. I see software development as a craft, and I am a big proponent of software architecture and clean code discipline-n-practices. I like to see the bigger picture and make a broader impact. I was also a Microsoft MVP for past 7 years on Visual Studio and Dev Technologies I can be reached at vidya_mct@yahoo.com or twitter @dotnetauthor
Leave a Reply