Using the OracleHelper class

Last week I moved some Data Access Layer code from MSSQL to Oracle and I started out downloading the Oracle provider for .NET from OTN. I thought that OracleHelper would work well with the provider from Oracle, but it didn't. At least not the provider for Oracle 9.2.

So I went with the System.Data.OracleClient namespace instead and it works like a charm.

The OracleHelper  that looks and works similar to the SqlHelper 2.0 class is available in the Nile 3.0 sample project from Microsoft.

2 Comments

  • You should also consider creating a DAL that will wrap the existing DAL objects of both SQL Servers (MSSQL and Oracle), so next you would like to move from one to another, you'll just need to change the connetion string.

  • Yes, I know, therefore I *have* such a wrapper class(es) that all my DAL classes inherit and use ;)



    I cannot control this from the connectionstring only, I need to change a few lines of code too. Eventually I'll code support for this too.

Comments have been disabled for this content.