Best adapter for SQL/Oracle

[Rob]

Hi,

I develop apps that need to user either SQL Server or Oracle for the RDBMS.
The engine varies from one site to the next (i.e. a client never needs to
connect to both at the same time).

So far I've been using the ODBC adapter, but recently ran into some issues
when using stored procedures, at which point I switched to the OleDb
adapter. So now I'm wondering if I should've been using the OleDb adapter
all along.

Does anyone have any advice, or links to articles that gives the advantges
of one over the other within a SQL/Oracle scenairio?

Appreciated,


Rob

 

[Miha Markic [MVP C#]]

Rob,

Why don't you try managed providers and use some sort of factory pattern?
It will give you speed and flexibility.

 

[Rob]

Hi Miha,

What do you mean by factory pattern? Any links to articles online?


Thanks,


Rob

Rob,

Why don't you try managed providers and use some sort of factory pattern?
It will give you speed and flexibility.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi,

I develop apps that need to user either SQL Server or Oracle for the
RDBMS.
The engine varies from one site to the next (i.e. a client never needs to
connect to both at the same time).

So far I've been using the ODBC adapter, but recently ran into some issues
when using stored procedures, at which point I switched to the OleDb
adapter. So now I'm wondering if I should've been using the OleDb adapter
all along.

Does anyone have any advice, or links to articles that gives the advantges
of one over the other within a SQL/Oracle scenairio?

Appreciated,


Rob

 

[Miha Markic [MVP C#]]

Hi Rob,

One way would be to deal only with interfaces (note that many of ado.net
classes have interfaces) - this way the code is pretty generic.
Also, you might check
http://www.dofactory.com/Patterns/PatternAbstract.aspx

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi Miha,

What do you mean by factory pattern? Any links to articles online?


Thanks,


Rob

Rob,

Why don't you try managed providers and use some sort of factory pattern?
It will give you speed and flexibility.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi,

I develop apps that need to user either SQL Server or Oracle for the
RDBMS.
The engine varies from one site to the next (i.e. a client never needs to
connect to both at the same time).

So far I've been using the ODBC adapter, but recently ran into some issues
when using stored procedures, at which point I switched to the OleDb
adapter. So now I'm wondering if I should've been using the OleDb adapter
all along.

Does anyone have any advice, or links to articles that gives the advantges
of one over the other within a SQL/Oracle scenairio?

Appreciated,


Rob