Typed DataSet - Migration to ODP.NET

Ptero · Oct 15, 2009, 05:10 AM

We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using System.Data.OracleClient. Our purpose is to make a migration to ODP.NET ( Oracle.DataAccess ). If i build a new typed dataset, it works fine with ODP. For migration of existing code i changed all references from System.Data.OracleClient to Oracle.DataAccess ( Both in Project References and also in Designer.cs files (manually)).
But existing code falls on Adapter get property - InitAdapter() function. The error is: "Value does not fall within the expected range". Any suggestions, please? Many thanks in advance for your help.

Oct 15, 2009, 05:10 AM	#1
Ptero DriverHeaven Newbie Join Date: Oct 2009 Posts: 2 Rep Power: 0	Typed DataSet - Migration to ODP.NET We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using System.Data.OracleClient. Our purpose is to make a migration to ODP.NET ( Oracle.DataAccess ). If i build a new typed dataset, it works fine with ODP. For migration of existing code i changed all references from System.Data.OracleClient to Oracle.DataAccess ( Both in Project References and also in Designer.cs files (manually)). But existing code falls on Adapter get property - InitAdapter() function. The error is: "Value does not fall within the expected range". Any suggestions, please? Many thanks in advance for your help.