C# Oracle 접속

Oracle.ManagedDataAccess 를 Nuget에서 설치한다.

<add name="ora" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ipaddress)(PORT=port)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbinfo)));User Id=id;Password=pwd;" providerName="Oracle.DataAccess.Client" />

using Oracle.ManagedDataAccess.Client;

 var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ora"].ConnectionString;
            using (OracleConnection con = new OracleConnection(connectionString))
            {         
                OracleDataAdapter adapter = new OracleDataAdapter(query, con);
                adapter.Fill(ds);
            }