Microsoft OracleClient to ODP.NET Application Migration: Factory Class Code Migration

If your application uses ADO.NET provider-independent code through factory classes, then migrating from Microsoft OracleClient to ODP.NET is quite simple. Modify the following line of code in your ADO.NET application.

C#:

  1. Find: DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
  2. Replace with: DbProviderFactory factory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");

Visual Basic:

  1. Find: Dim factory As DbProviderFactory = DbProviderFactories.GetFactory("System.Data.OracleClient")
  2. Replace with: Dim factory As DbProviderFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client")

You may also need to modify the connection string if you use Microsoft OracleClient attributes not available in ODP.NET.

Next step: ODP.NET Deployment