Best adapter for SQL/Oracle

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
Rob,

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

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


Thanks,


Rob

Miha Markic said:
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

Rob said:
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
Click to expand...
Click to expand...
 
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

Rob said:
Hi Miha,

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


Thanks,


Rob

Miha Markic said:
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

Rob said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top