Click to See Complete Forum and Search --> : Data binding and Oracle managed provider


Alexepascual
October 24th, 2009, 07:23 PM
I was trying to find examples of programming data binding using the managed Oracle provider but can't find any. All I find are examples that use the OLE DB provider.
I wonder if there is some limitation where the managed providers (either the one supplied by oracle or the one by Microsoft) do not allow implementation of data binding.
If this is the case, I would appreciate it if you explain why.

Alexepascual
October 26th, 2009, 12:18 PM
As I didn't get any answers I did some experimentation.
I did the binding by following the available examples which use the IDE to create the adapter, connection and dataset. I selected the OLE DB provider for Oracle as there are no managed providers listed in the Data Link Properties dialog.
One thing I noticed is that the objects that were created by this automated process used the namespace "System.Data.OracleClient" which I thought it was connected to the Microsoft managed oracle provider and not the OLE DB provider for Oracle. But maybe I am mistaken and both providers have the same namespace. (I just noticed that a reference has been created to the System.Data.Oracleclient.dll , so I'll have to look into this)
After my application was running, I did a search and replace of "System.Data.OracleClient" with "Oracle.DataAccess.Client" (I already had a reference to the DLL for this project) . The project compliled without errors but I got some problems with some types that differ from one provider to the other. After replacing those types with the ones needed by the new provider everything worked OK.