locked
Synchronizing Oracle Database without System.Data.OracleClient RRS feed

  • Question

  • Hello-

    I'm wanting to use the Sync Framework to synchronize SQL Server CE with an Oracle backend.  I've found several examples of how to do this including the sample application located here:

    http://blogs.msdn.com/b/synchronizer/archive/2007/03/09/demo-v-offlineapplication-oracle-backend.aspx

    This example, along with all the others I've found, use the classes in the System.Data.OracleClient namespace.  According to MSDN, this entire API has been deprecated and is encouraging users to avoid using these classes and instead find another third-party provider: http://msdn.microsoft.com/en-us/library/77d8yct7.aspx

    We are currently using the fully supported ODP.NET provider from Oracle but when I tried to use the classes from the Oracle provider I get the following exception when setting the commands on the server provider:

    Unable to cast object of type 'Oracle.DataAccess.Client.OracleParameter' to type 'System.Data.Common.DbParameter'

    I'd rather not use the deprecated provider since MS is clearly stating that it will be removed from future versions of the framework eventually.  Does anyone know how to use ODP.NET with the Sync Framework or have any suggestions for other third-party Oracle providers that work with the Sync Framework?

    Thanks

    -Roberto

    Tuesday, August 10, 2010 5:13 PM

Answers

All replies