How to connect to Oracle DB from Visual studio using ODP.NET (Oracle.ManagedDataAccess.dll)

Oracle introduced new dll to connect Oracle database from .NET.

1. Down load latest ODP.net package from oracle site. You should download the correct version of package based on your visual studio version
2. You can check the link for the right version
   http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
    
3. After install you can find the Oracle.ManagedDataAccess.dll @
   D:\xxxxxxxxx\product\12.1.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll
    
4. Add the dll as a reference to your project solution in Visual studio.
5. using Oracle.ManagedDataAccess.Client;