Converting an Oracle Data Reader into a SQL Server Data Reader

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody,


Does anybody know if it is possible to convert an
Oracle Data Reader into a SQL Server Data Reader.
I unsucessfully tried using the Ctype function.
My problem is that I am developing a system that
should work with both SQL Server 2000 and Oracle 9i.
So I would like to use the same classes and methods to
access both databases.
Does anyone did it before?


Thanks a lot,


Amintas
 
Hi everybody,


Does anybody know if it is possible to convert an
Oracle Data Reader into a SQL Server Data Reader.
I unsucessfully tried using the Ctype function.
My problem is that I am developing a system that
should work with both SQL Server 2000 and Oracle 9i.
So I would like to use the same classes and methods to
access both databases.
Does anyone did it before?
Click to expand...
Your code that should work with both databases should use IDataReader
types, like (using VB, since you mention CType)

' Create a datareader for the current database, can be oracle or sqlserver
Dim myDataReader As IDataReader = CreateDataReader()
' now work with the myDataReader as you do now, it should work.

Frans
 
Hi,

In addition to Frans.
IOW Frans is talking about factory pattern - where you use interfaces
instead of specialized classed.
The other way would be to use OleDb namespace (with some speed cost).
 
Hi Frans and Miha,


Thank you very much for your support.
I have tried the interface approach proposed by Frans.
I worked beautifully!
That's exactly what I was looking for since I will have
better performance.
Thanks again!


Cheers,



Amintas
 
Back
Top