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); }