private bool Connect(ProductDbType dbType, DatabaseProperties databaseProperties) { IDatabaseFunctions databaseFunctions; if (dbType == ProductDbType.Oracle) { databaseFunctions = new OracleOperationFunctions(databaseProperties); } else { databaseFunctions = new SqlServerOperationFunctions(databaseProperties); } try { _isConnectionDefined = databaseFunctions.TestConnection(); DatabaseFunctions = databaseFunctions; return(_isConnectionDefined); } catch (Exception ex) { Logger.Error(ex, ex.Message); throw ex; } }
public static string GetConnectionString(DatabaseProperties databaseProperties, ProductDbType dbType) { if (dbType == ProductDbType.Oracle) { return(string.Format(_oracleConnectionString, databaseProperties.DatabaseUser, databaseProperties.DatabasePassword, databaseProperties.ServerOrTns)); } else if (dbType == ProductDbType.SqlServer) { if (databaseProperties.IsTrustedConnection) { return(string.Format(_sqlServerTrustedConnectionString, databaseProperties.ServerOrTns, databaseProperties.DatabaseName)); } else { return(string.Format(_sqlServerConnectionString, databaseProperties.ServerOrTns, databaseProperties.DatabaseName, databaseProperties.DatabaseUser, databaseProperties.DatabasePassword)); } } return(null); }
public SqlServerOperationFunctions(DatabaseProperties databaseProperties) : base(databaseProperties) { SetConnectionString(ProductConnectionString.GetConnectionString(databaseProperties, ProductDbType.SqlServer)); }
public OracleOperationFunctions(DatabaseProperties databaseProperties) : base(databaseProperties) { base.SetConnectionString(ProductConnectionString.GetConnectionString(databaseProperties, ProductDbType.Oracle)); Environment.SetEnvironmentVariable("nls_lang", "AMERICAN_AMERICA.WE8MSWIN1252"); }
protected BaseDatabaseOperationFunctions(DatabaseProperties databaseProperties) { DatabaseProperties = databaseProperties; }
public bool SetConnection(ProductDbType dbType, DatabaseProperties databaseProperties) => Connect(dbType, databaseProperties);
private bool Connect(ProductDbType dbType) { DatabaseProperties databaseProperties = RequestDbInputsProperties(dbType); return(Connect(dbType, databaseProperties)); }