I'm looking for a third-party Oracle Data Provider for .Net (ADO.NET) with a full support of Oracle object types (like geometries). I was foolish enough to use ODP.NET and now I'm paying the price - it's incredibly buggy and I just reached the end of the line (keep crashing IIS Pool - known issue, no resolution). I found dotConnect which is fine, just 4 times slower with object types than ODP.NET. Are any others providers which support Oracle objects?
A:
Are you aware of the Oracle-published ADO.net provider ? this dll ships with the Oracle CLient, and is named Oracle.DataAccess.dll. The version I am using is ver 1.102.4.0, and is dtd 2/11/2008.
Charles Bretana
2009-06-29 23:57:46
This will be deprecated in the next version of C#
jle
2009-06-30 00:02:15
Hi Charles,I've checked this file, still its ODP driver (your is actually from version 10.2.4 - no support for objects). 11g Client supports objects, but it's already given me such a headache - pooling failing, metadata cache broken, and now these problems in IIS - nightmare.
Karol Kolenda
2009-06-30 00:26:08
A:
There is also this provider: http://www.datadirect.com/products/net/net_for_oracle/index.ssp . I don't know whether it supports spatial type mdsys.sdo_geometry.
Theo
2009-06-30 07:05:37
Hi Theo,No they don't supporty Oracle object types. I've already contacted them and unfortunatelly only "normal" types are supported. I guess I'll choose dotConnect - a performance hit is a small price to pay for quality.
Karol Kolenda
2009-06-30 13:55:17