SV: ADO.Net Database Providers

Oracle now has a fully managed .net provider. It does not need a full Oracle client installed. .Net programmers love it. It works great, has a few documented limitations compared with the unmanaged ODP.NET Provider.

Visual Studio users should get ODAC with ODT (has design time support for Microsoft Entity Framework 6). For runtime the provider has a footprint of about 5 MB. Current release is 12.1.0.2 Release 4. Works fine with Oracle 11 and 12 (and probably also earlier releases.

If the (few) limitations compared with the unmanaged provider are a problem, use ODP.NET unmanaged (which is included in a full client install). Read the full documentation in “Data Provider for .NET Developer's Guide for Microsoft Windows”.

Regards Niels

Fra: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] På vegne af Dennis Williams Sendt: 17. oktober 2016 23:25
Til: oracle-l_at_freelists.org
Emne: ADO.Net Database Providers

Dear List,

What is a good database provider to use with ADO.NET<http://ADO.NET>? Any recommendations?

I have some developers who are migrating from VB6 to .Net with Oracle 11g.

Thanks,
Dennis Williams

--
http://www.freelists.org/webpage/oracle-l