[Marley]

Как подключиться к БД 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;";