Not everyone knows, but from 12c version of Oracle DB lot of things are changing, just take a look on below:
Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. The data provider can be used with the latest .NET Framework 4.5.1 version.
- ODP.NET makes using Oracle from .NET more flexible, faster, and more stable.
- ODP.NET includes many features not available from other .NET drivers, including flexible LOB data types, self-tuning, run-time connection load balancing, fast connection failover, and Advanced Queuing.
- This release includes the fully-managed ODP.NET, multitenant container database support, Identity column support, native PL/SQL Boolean data type, and Transaction Guard.
- ODP.NET, Managed Driver is 100% .NET code. Developers can deploy a single assembly, side by side with other ODP.NET versions easily in a deployment package smaller than 10 MB.