internal static string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig, string datasource, bool isAdminMode) { var adminUser = dbConfig.AdminUser; var adminPassword = dbConfig.AdminPassword; if (isAdminMode && dbConfig is IDbConfig dbConfigFull) { if (dbConfigFull.IsAdminValuesValid == false) { adminUser = ""; adminPassword = ""; } ; } var poolingStr = $"{dbConfig.Pooling}"; if (dbConfig.Pooling && dbConfig.PoolingKeyValues?.Any() == true) { // ReSharper disable once LoopCanBeConvertedToQuery foreach (var keyValue in dbConfig.PoolingKeyValues) { poolingStr += $";{keyValue.Key} = {keyValue.Value}"; } } var connectionString = string.Format(DefaultConnectionStringTemplate, (isAdminMode ? adminUser : dbConfig.User)?.ToUpper(), isAdminMode ? adminPassword : dbConfig.Password, datasource, poolingStr, GetConnectionTimeout(dbConfig)); return(connectionString); }
private static string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig, bool isAdminMode) { var adminUser = dbConfig.AdminUser; var adminPassword = dbConfig.AdminPassword; if (isAdminMode && dbConfig is IDbConfig dbConfigForValidation) { if (dbConfigForValidation.IsAdminValuesValid == false) { adminUser = ""; adminPassword = ""; } ; } var connectionString = string.Format(DefaultConnectionStringTemplate, (isAdminMode ? adminUser : dbConfig?.User)?.ToLower(), isAdminMode ? adminPassword : dbConfig?.Password, dbConfig?.Hostname, dbConfig?.Port, dbConfig?.DatabaseName.ToLower(), dbConfig?.Pooling, GetConnectionTimeout(dbConfig)); return(connectionString); }
internal static string GetDataSource(IDbConnectionStringBuilderConfig dbConfig) { var dataSource = dbConfig.Datasource; return(!string.IsNullOrEmpty(dataSource) ? dataSource : GetDefaultDataSource(dbConfig.Hostname, dbConfig.Port, dbConfig.GetOracleServiceName()?.ToLower())); }
/// <summary> /// <para>Get the oracle service name from config</para> /// 1. Get config "database:dataSource".<br/> /// 2. If config "database:dataSource" is NULL, get <see cref="IDbConfigDatabaseTargets.DatabaseName"><paramref name="dbConfig"/>.DatabaseName</see><br/><br/> /// ------ See <see cref="IDbConfigDatabaseTargets.DatabaseName"/> ---------------------------<br/> /// <br/> /// Get <inheritdoc cref="IDbConfigDatabaseTargets.DatabaseName" path="/summary/remarks[1]"/> /// </summary> /// <param name="dbConfig"></param> /// <returns></returns> public static string GetOracleServiceName(this IDbConnectionStringBuilderConfig dbConfig) { if (dbConfig is IDbConfig dbConfigFull) { return(dbConfigFull.GetConfigValue(dbConfigFull.GetConfigKey("database", "dataSource")) ?? dbConfig.DatabaseName); } return(dbConfig.DatabaseName); }
internal static string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig, string datasource, bool isAdminMode) { var connstr = string.Format(DefaultConnectionStringTemplate, (isAdminMode ? dbConfig.AdminUser : dbConfig.User).ToUpper(), isAdminMode ? dbConfig.AdminPassword : dbConfig.Password, datasource, dbConfig.Pooling, GetConnectionTimeout(dbConfig)); return(connstr); }
private static string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig, bool isAdminMode) { var connstr = string.Format(DefaultConnectionStringTemplate, (isAdminMode ? dbConfig.AdminUser : dbConfig.User).ToLower(), isAdminMode ? dbConfig.AdminPassword : dbConfig.Password, dbConfig.Hostname, dbConfig.Port, dbConfig.DatabaseName.ToLower(), dbConfig.Pooling, GetConnectionTimeout(dbConfig)); return(connstr); }
private static string GetConnectionTimeout(IDbConnectionStringBuilderConfig dbConfig) { return(string.IsNullOrEmpty(dbConfig.ConnectionTimeoutInSecs) ? string.Empty : string.Format(ConnectionTimeoutTemplate, dbConfig.ConnectionTimeoutInSecs)); }
internal static string GetDataSourceTemplate(IDbConnectionStringBuilderConfig dbConfig) { return(!string.IsNullOrEmpty(dbConfig.Datasource) ? dbConfig.Datasource : GetDefaultDataSource(dbConfig.Hostname, dbConfig.Port, dbConfig.DatabaseName?.ToLower())); }
public string BuildAdminConnectionString(IDbConnectionStringBuilderConfig dbConfig) => BuildConnectionString(dbConfig, GetDataSourceTemplate(dbConfig), true);
public string BuildAdminConnectionString(IDbConnectionStringBuilderConfig dbConfig) { return(BuildConnectionString(dbConfig, true)); }
public string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig) { return(BuildConnectionString(dbConfig, false)); }
public string BuildConnectionString(IDbConnectionStringBuilderConfig dbConfig) => BuildConnectionString(dbConfig, GetDataSource(dbConfig), false);