Thursday, April 4, 2013

No more System.Data.OracleClient

from Artinsoft's blog:

 Microsoft announced that they won’t support the System.Data.OracleClient anymore :(

The message says that it will still be available in .NET 4.0 but “deprecated” and that it wont impact existing applicatoions.

So what are my options?
Well you have to go to a third party. Not now but eventually.

Migration to ODP.NET
Oracle provide general instructions. In summary you need to:
  1. Add the references to Oracle.DataAccess
  2. Change namespaces: System.Data.OracleClient by  Oracle.DataAccess.Client; and maybe add “using Oracle.DataAccess.Types”
  3. Update the connection String (most attributes are the same). Change Integrated Security by  "User Id=/", change “Server” attribute to “Data Source” and remove Unicode
  4. The following is anoying but you have to add after all OracleCommands something like OracleCommand1.BindByName = true;
  • Oracle Universal Installer (either in normal installation or Silent Install)
  • XCopy (I like this :) ) just remember to download the ODAC xcopy version

No comments: