Как подключиться к БД Oracle с помощью C# .NET
string oradbConnectionString = "Data Source=(DESCRIPTION="
+ "(ADDRESS_LIST="
+ "(ADDRESS="
+ "(PROTOCOL=TCP)"
+ "(HOST=ORASRVR)"
+ "(PORT=1521)"
+ ")"
+ ")"
+ "(CONNECT_DATA="
+ "(SERVER=DEDICATED)"
+ "(SERVICE_NAME=ORCL)"
+ ")"
+ ");"
+ "User Id=scott;Password=tiger;";
или так
string oradbConnectionString = "Data Source=(DESCRIPTION=" +
"(ADDRESS_LIST=" +
"(ADDRESS=" +
"(PROTOCOL=TCP)" +
"(HOST=ORASRVR)" +
"(PORT=1521)" +
")" +
")" +
"(CONNECT_DATA=" +
"(SERVER=DEDICATED)" +
"(SERVICE_NAME=ORCL)" +
")" +
");" +
"User Id=scott;Password=tiger;";