Anyone have experience with the provider from Microsoft vs. the one from
Oracle? I haven't looked very much at either.
One would assume that the one written by Oracle itself should perform
better, since they should be able to optimize it?

Any sort of feedback or experience with either of these?

I used MSDAORA with Oracle and it seemed to work the best for my ASP.Net 1.1.


"Marina Levit [MVP]" wrote:

> Anyone have experience with the provider from Microsoft vs. the one from
> Oracle? I haven't looked very much at either.
> One would assume that the one written by Oracle itself should perform
> better, since they should be able to optimize it?
>
> Any sort of feedback or experience with either of these?
>
>
>

Marina,

In my opinion a typical question for Frans Bouma, you know the one I have
always those big fights with in these newsgroups.

I did not see him a while here so mail me, than I sent you his email adres.
You have to translate my emailadress first of course.

Cor


"Marina Levit [MVP]" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Anyone have experience with the provider from Microsoft vs. the one from
> Oracle? I haven't looked very much at either.
> One would assume that the one written by Oracle itself should perform
> better, since they should be able to optimize it?
>
> Any sort of feedback or experience with either of these?
>

My application can use both, our data abstraction layer permits changing the
provider from an external xml configuration file. In fact to any provider
targeting that database that was decent written. Then I was able to do quite
easy tests of speed and so.
So yes, the Oracle is faster ... Take care also that they make different
casts inside the readers get methods, this if you plan to try one and then
try the other.
With the Oracle, redistribution is the strangest part, the Microsoft handled
that more elegant.


"Cor Ligthert [MVP]" wrote:

> Marina,
>
> In my opinion a typical question for Frans Bouma, you know the one I have
> always those big fights with in these newsgroups.
>
> I did not see him a while here so mail me, than I sent you his email adres.
> You have to translate my emailadress first of course.
>
> Cor
>
>
> "Marina Levit [MVP]" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
> > Anyone have experience with the provider from Microsoft vs. the one from
> > Oracle? I haven't looked very much at either.
> > One would assume that the one written by Oracle itself should perform
> > better, since they should be able to optimize it?
> >
> > Any sort of feedback or experience with either of these?
> >
>
>
>

Marina Levit [MVP] wrote:

> Anyone have experience with the provider from Microsoft vs. the one
> from Oracle? I haven't looked very much at either.
> One would assume that the one written by Oracle itself should perform
> better, since they should be able to optimize it?

MS' version doesn't support the XML type, it always returns any
NUMBER(x,y) as decimal and doesn't have some of the fancy features
ODP.NET supports. There are also minor issues with varchar fields: you
can't save a UNICODE encoded string in a varchar field, because when
you set the parameter's OracleType to VarChar, it will result into
using DbType.AnsiString under the hood, allowing only non-unicoded
strings. This is of course to support 8i, but when you're using 9i or
higher this sucks bigtime if you need to store unicoded strings.

ODP.NET and MS' provider are on par with performance, as both rely on
the Oracle CLI (client interface). You have to install the client no
matter what, so with MS' provider you've to install the client
separately, with ODP.NET you get the client installed.

I'd pick ODP.NET without any hesitation. Not only does it support more
features but you can say what you want about Oracle, they DO release
bugfixes from time to time, while Microsoft is very slow to release
bugfixes (service packs for .net framework).

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

Thanks to everyone who responded.

"Marina Levit [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Anyone have experience with the provider from Microsoft vs. the one from
> Oracle? I haven't looked very much at either.
> One would assume that the one written by Oracle itself should perform
> better, since they should be able to optimize it?
>
> Any sort of feedback or experience with either of these?
>

I do stand by what I said (but if I’m wrong I leaned something).
Of what version of Oracle are we talking?
I do suppose that are we talking about .Net 2.0 providers.


"Frans Bouma [C# MVP]" wrote:

> Marina Levit [MVP] wrote:
>
> > Anyone have experience with the provider from Microsoft vs. the one
> > from Oracle? I haven't looked very much at either.
> > One would assume that the one written by Oracle itself should perform
> > better, since they should be able to optimize it?
>
> MS' version doesn't support the XML type, it always returns any
> NUMBER(x,y) as decimal and doesn't have some of the fancy features
> ODP.NET supports. There are also minor issues with varchar fields: you
> can't save a UNICODE encoded string in a varchar field, because when
> you set the parameter's OracleType to VarChar, it will result into
> using DbType.AnsiString under the hood, allowing only non-unicoded
> strings. This is of course to support 8i, but when you're using 9i or
> higher this sucks bigtime if you need to store unicoded strings.
>
> ODP.NET and MS' provider are on par with performance, as both rely on
> the Oracle CLI (client interface). You have to install the client no
> matter what, so with MS' provider you've to install the client
> separately, with ODP.NET you get the client installed.
>
> I'd pick ODP.NET without any hesitation. Not only does it support more
> features but you can say what you want about Oracle, they DO release
> bugfixes from time to time, while Microsoft is very slow to release
> bugfixes (service packs for .net framework).
>
> FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------
>

On Tue, 21 Nov 2006 13:14:42 -0500, "Marina Levit [MVP]" <(E-Mail Removed)> wrote:

¤ Anyone have experience with the provider from Microsoft vs. the one from
¤ Oracle? I haven't looked very much at either.
¤ One would assume that the one written by Oracle itself should perform
¤ better, since they should be able to optimize it?
¤
¤ Any sort of feedback or experience with either of these?
¤

Oracle's provider's generally support more native features, but I've generally found then to be a
bit more buggy. Also, keep in mind that ODP.NET requires the 9i client version or higher.


Paul
~~~~
Microsoft MVP (Visual Basic)

Frans,

> while Microsoft is very slow to release
> bugfixes (service packs for .net framework).
>
I have seen they are changing their policy, so I would not write this
anymore or at least write "was", they have showed they listen in this to
their customers..

Cor

MrSmersh wrote:

> I do stand by what I said (but if I’m wrong I leaned something).

that's great but my experiences are different. Also, it's not easy to
swap providers, because of the NUMBER(x, y) -> .NET type mappings which
differ alot between ODP.NET and MS' oracle provider.

> Of what version of Oracle are we talking?

that doesnt' matter.

> I do suppose that are we talking about .Net 2.0 providers.

that also doesn't matter in this case.

FB

>
>
> "Frans Bouma [C# MVP]" wrote:
>
> > Marina Levit [MVP] wrote:
> >
> > > Anyone have experience with the provider from Microsoft vs. the
> > > one from Oracle? I haven't looked very much at either.
> > > One would assume that the one written by Oracle itself should
> > > perform better, since they should be able to optimize it?
> >
> > MS' version doesn't support the XML type, it always returns any
> > NUMBER(x,y) as decimal and doesn't have some of the fancy features
> > ODP.NET supports. There are also minor issues with varchar fields:
> > you can't save a UNICODE encoded string in a varchar field, because
> > when you set the parameter's OracleType to VarChar, it will result
> > into using DbType.AnsiString under the hood, allowing only
> > non-unicoded strings. This is of course to support 8i, but when
> > you're using 9i or higher this sucks bigtime if you need to store
> > unicoded strings.
> >
> > ODP.NET and MS' provider are on par with performance, as both rely
> > on the Oracle CLI (client interface). You have to install the
> > client no matter what, so with MS' provider you've to install the
> > client separately, with ODP.NET you get the client installed.
> >
> > I'd pick ODP.NET without any hesitation. Not only does it support
> > more features but you can say what you want about Oracle, they DO
> > release bugfixes from time to time, while Microsoft is very slow to
> > release bugfixes (service packs for .net framework).


--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------