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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] På ;
vegne af Dennis Williams
Sendt: 17. oktober 2016 23:25
Til: oracle-l@xxxxxxxxxxxxx
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