locked
What should I use instead of OracleConnection?

    Question

  • I've got a .NET 4 project which uses the OracleConnection class from System.Data.OracleClient.  This gives me an ObsoleteAttribute warning: "OracleConnection has been deprecated.  http://go.microsoft.com/fwlink/?LinkID=144260"  Following the link just takes me to the System.Data.OracleClient documentation: I can't see an indication of what I'm meant to use instead.

    What should I use instead of OracleConnection to connect to an Oracle database in .NET 4?
    Mindscape WPF controls: http://www.mindscape.co.nz/products/
    Wednesday, June 10, 2009 4:34 AM

Answers

  • Hi Ivan,

    In .NET 4 OracleClient has been marked as Deprecated and should give you this warning. This will have no impact to existing applications and these applications will continue to work as expected. Developing new applications which use OracleClient will be supported; however, the warning you see will be raised if the applications are compiled against .Net 4.0. Once compiled, no warnings or errors will be generated while running these applications. We strongly recommend customers use one of our partners’ ADO.NET Providers for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.
    • Oracle offers their ODP.NET provider
    • DataDirect offers an Oracle provider for .NET
    • DevArt offers an Oracle provider for .NET, etc.

    Microsoft will continue to provide hotfixes for critical issues in System.Data.OracleClient as per the standard support policy for .Net Framework 4.0. We will also continue to make critical bug fixes in future service packs for .Net Framework 4.0.

    Thank you,
    Elisa Flasko
    Program Manager, Data Programmability

    Tuesday, June 16, 2009 4:41 PM

All replies

  • Hi Ivan,

    In .NET 4 OracleClient has been marked as Deprecated and should give you this warning. This will have no impact to existing applications and these applications will continue to work as expected. Developing new applications which use OracleClient will be supported; however, the warning you see will be raised if the applications are compiled against .Net 4.0. Once compiled, no warnings or errors will be generated while running these applications. We strongly recommend customers use one of our partners’ ADO.NET Providers for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.
    • Oracle offers their ODP.NET provider
    • DataDirect offers an Oracle provider for .NET
    • DevArt offers an Oracle provider for .NET, etc.

    Microsoft will continue to provide hotfixes for critical issues in System.Data.OracleClient as per the standard support policy for .Net Framework 4.0. We will also continue to make critical bug fixes in future service packs for .Net Framework 4.0.

    Thank you,
    Elisa Flasko
    Program Manager, Data Programmability

    Tuesday, June 16, 2009 4:41 PM
  • Also, here is an ADO.NET blog post about the OracleClient deprecation:

    http://blogs.msdn.com/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 17, 2009 6:12 PM
  • Devart offers fast and reliable ADO.NET provider for the wide range of users. One can choose the best Edition of our provider to fit his or her needs. For example:
    - You don't need advanced functionality and you don't have money to spend - then free Express Edition is just for you. It offers functionality similar to the one of Oracle Client, it is free and easy to install. All you have to do is to place two assemblies in GAC. - You want to develop and deploy database applications with ease?
    - Get our Standard Edition with design time support, profiler for monitoring queries that are being executed in the application, and the ability to work without Client Software installed.
    - You want more advanced features, you need all the functionality Oracle can give? - Then Professional Edition with the newest Microsoft and Devart technologies implementation will put them at your fingertips! In it, strong points are Entity Framework support implemented since the release of the first Beta, LINQ to Oracle, and, above all, Entity Developer - our own tool for building LINQ and Entity Framework models, functionality and convenience of which exceed those offered by the standard ones a lot. You are also welcome to take advantage of using Oracle advanced functionality, ASP.NET 2.0 providers, SQL Server Business Intelligence Solutions, Enterprise Library and much more with our ADO.NET provider for Oracle.
    - You are not sure if you can rely on the quality of third-party components? With us you will get regular builds with fixes every two or three weeks and fast comprehensive support from our team that will help you resolve any issue. Besides, the interface of our provider is compatible with System.Data.OracleClient. We are sure that with the supplied Migration Wizard tool and our support migration of your project will be fast, easy, and convenient.
    Try it out!
    Devart Team
    http://www.devart.com/dotconnect
    ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support
    Monday, August 03, 2009 2:44 PM
  • Now you can migrate your application from OracleClient to Devart dotConnect for Oracle in two single steps. For more information please refer to this article http://www.devart.com/blogs/dotconnect/?p=67.
    Devart Team
    http://www.devart.com/dotconnect
    ADO.NET data providers for Oracle, MySQL, PostgreSQL, SQLite with Entity Framework and LINQ to SQL support
    Thursday, September 10, 2009 12:27 PM