Best adapter for SQL/Oracle


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
 
Ad

Advertisements

M

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.
 
R

Rob

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
 
Ad

Advertisements

M

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top