By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

Oracle Data Provider

P: n/a
Dom
Someone in a post mentioned the Oracle Data Provider. Can anyone tell
me about it? I'd like to know the following:

1. Is it much faster than OleDB?

2. Is it essentially the same approach, eg, new Connection, new
Command, set CommandText, ExecuteDataRead(), cursor through a
DataReader, and so on?

3. Is it something I just download from Oracle and then install? Is
there any downside? (Computer becomes slower, whatever).

Thanks,
Dom
Dec 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Oracle Data Provider is a connection component that allows you to connect to
an Oracle database. You can CommandText, DataReader, DataSets, etc. I'm
using is now to connect to our Oracle warehouse and using all of the above
to execute my queries and return my data.
"Dom" <do********@gmail.comwrote in message
news:60**********************************@d27g2000 prf.googlegroups.com...
Someone in a post mentioned the Oracle Data Provider. Can anyone tell
me about it? I'd like to know the following:

1. Is it much faster than OleDB?

2. Is it essentially the same approach, eg, new Connection, new
Command, set CommandText, ExecuteDataRead(), cursor through a
DataReader, and so on?

3. Is it something I just download from Oracle and then install? Is
there any downside? (Computer becomes slower, whatever).

Thanks,
Dom

Dec 17 '07 #2

P: n/a
Any ADO.NET database-specific provider should be more efficient than OleDb.
If the provider is written correctly, it will have the same semantics. That's
why you have the interfaces for the providers - e.g. IDbCommand, IDataReader,
etc.
--Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com
"Dom" wrote:
Someone in a post mentioned the Oracle Data Provider. Can anyone tell
me about it? I'd like to know the following:

1. Is it much faster than OleDB?

2. Is it essentially the same approach, eg, new Connection, new
Command, set CommandText, ExecuteDataRead(), cursor through a
DataReader, and so on?

3. Is it something I just download from Oracle and then install? Is
there any downside? (Computer becomes slower, whatever).

Thanks,
Dom
Dec 17 '07 #3

P: n/a
On Dec 17, 6:48 am, Dom <dolivas...@gmail.comwrote:
Someone in a post mentioned the Oracle Data Provider. Can anyone tell
me about it? I'd like to know the following:

1. Is it much faster than OleDB?

2. Is it essentially the same approach, eg, new Connection, new
Command, set CommandText, ExecuteDataRead(), cursor through a
DataReader, and so on?

3. Is it something I just download from Oracle and then install? Is
there any downside? (Computer becomes slower, whatever).

Thanks,
Dom
I've used Oracle's .net provider, and have been very happy with it.
It's definitely faster than going through oledb.

MS was nice enough to provide a comparison of the the MS offering and
Oracle's:

http://msdn2.microsoft.com/en-us/library/ms971518.aspx

It's dated, but it gives the idea.

Oracle's explanation of the speed improvement can be found somewhere
on their ODP.NET site. Bascially, the reason they give is that there
aren't layers-upon-layers to go through in making db accesses thru
ODP.NET

Downside to ODP.NET: deployment. Every client computer running
the .net-with-ODP.NET code must have odp.net installed - not just,
say, the computer with the db on it. This becomes annoying, and Oracle
has been hounded about this for some time. Possibly they've resolved
the deployment hassle - it's been awhile since I've used it.
Dec 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.