ORACLE Archives - icodebroker

[C#/COMMON/ORACLE] Oracle 연결 문자열 구하기

■ Oracle 연결 문자열을 구하는 방법을 보여준다. ▶ Oracle 연결 문자열 구하기 (C#)


string connectionString = GetOracleConnectionString("127.0.0.1", "1521", "orcl", "SYSTEM", "1234");

string connectionString = GetOracleConnectionString("127.0.0.1", "1521", "orcl", "SYSTEM", "1234");

▶ Oracle 연결 문자열 구하기 (C#)


#region Oracle 연결 문자열 구하기 - GetOracleConnectionString(host, port, serviceName, userID, password)

/// <summary>
/// Oracle 연결 문자열 구하기
/// </summary>
/// <param name="host">호스트</param>
/// <param name="port">포트</param>
/// <param name="serviceName">서비스명</param>
/// <param name="userID">사용자 ID</param>
/// <param name="password">패스워드</param>
/// <returns>Oracle 연결 문자열</returns>
public string GetOracleConnectionString(string host, string port, string serviceName, string userID, string password)
{
    string dataSourceFormat = @"
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = {0})(PORT = {1}))
        )
        (CONNECT_DATA =
            (SERVICE_NAME = {2})
        )
    )";

    string dataSource = string.Format(dataSourceFormat, host, port, serviceName);

    string connectionString = string.Format("Data Source={0};User ID={1};Password={2}", dataSource, userID, password);

    return connectionString;
}

#endregion

#region Oracle 연결 문자열 구하기 - GetOracleConnectionString(host, port, serviceName, userID, password)

/// <summary>

/// Oracle 연결 문자열 구하기

/// </summary>

/// <param name="host">호스트</param>

/// <param name="port">포트</param>

/// <param name="serviceName">서비스명</param>

/// <param name="userID">사용자 ID</param>

/// <param name="password">패스워드</param>

/// <returns>Oracle 연결 문자열</returns>

public string GetOracleConnectionString(string host, string port, string serviceName, string userID, string password)

{

string dataSourceFormat = @"

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = {0})(PORT = {1}))

)

(CONNECT_DATA =

(SERVICE_NAME = {2})

)

)";

string dataSource = string.Format(dataSourceFormat, host, port, serviceName);

string connectionString = string.Format("Data Source={0};User ID={1};Password={2}", dataSource, userID, password);

return connectionString;

}

#endregion

[C#/COMMON/ORACLE] Oracle 데이터베이스 사용하기

■ Oracle 데이터베이스를 사용하는 방법을 보여준다. ▶ 예제 코드 (C#)


using System;
using System.Data;

using Oracle.DataAccess.Client;

string serviceName = @"
(DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
        (SERVICE_NAME = orcl)
    )
)";

string sql = "SELECT SYSDATE FROM DUAL";

DataSet set = new DataSet();

OracleConnection connection =  new OracleConnection("Data Source=" + serviceName + ";User ID=SYSTEM;Password=1234");

connection.Open();

OracleDataAdapter OrcleAd = new OracleDataAdapter(sql, connection);

connection.Close();

OrcleAd.Fill(set);

Console.WriteLine(set.Tables[0].Rows[0][0].ToString());

using System;

using System.Data;

using Oracle.DataAccess.Client;

string serviceName = @"

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)";

string sql = "SELECT SYSDATE FROM DUAL";

DataSet set = new DataSet();

OracleConnection connection = new OracleConnection("Data Source=" + serviceName + ";User ID=SYSTEM;Password=1234");

connection.Open();

OracleDataAdapter OrcleAd = new OracleDataAdapter(sql, connection);

connection.Close();

OrcleAd.Fill(set);

Console.WriteLine(set.Tables[0].Rows[0][0].ToString());

※ 첨부 파일을 참조한다. Oracle.DataAccess.zip