I know the MS Oracle driver handles data types a bit differently, but other than that, is there any reason to go with ODP.NET over MS Oracle? ODP.NET can be a pain to configure, and MS Oracle comes with the framework (smaller installer for us). I have only used ODP.NET, what are others doing?

Thanks

From the docs:

Not supported, due to restrictions in the Microsoft Oracle provider: XMLType, as that type isn't supported by the Microsoft Oracle provider All NUMBER(x, y) types are seen as System.Decimal. This can be a huge disadvantage. In that case, consider using an ODP.NET based driver

Walaa wrote:

From the docs:

Not supported, due to restrictions in the Microsoft Oracle provider: XMLType, as that type isn't supported by the Microsoft Oracle provider All NUMBER(x, y) types are seen as System.Decimal. This can be a huge disadvantage. In that case, consider using an ODP.NET based driver

Thanks