public Extras(ConnectionServerInf conInf)
{
_UserId = conInf.UserId;
_Password = conInf.Password;
_Host = conInf.Host;
_Port = conInf.Port;
_Service_Name = conInf.Service_Name;
}
public static OracleConnection OracleConnection(ConnectionServerInf conSVInf)
{
string _con = $"User Id={conSVInf.UserId};Password={conSVInf.Password};Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={conSVInf.Host})(PORT={conSVInf.Port}))(CONNECT_DATA=(SERVICE_NAME={conSVInf.Service_Name})));";
OracleConnection conn = new OracleConnection(_con); // C#
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
return(conn);
}
