Using ODP.NET without tnsnames.ora using Oracles OracleConnection

Connection string

This Oracle Data Provider for .NET / ODP.NET connection string can be used for connections to Oracle.

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));
User Id
=myUsername;
Password=myPassword;

Article: "Oracle Data Provider for .NET" by Rama Mohan