public NewDatabaseParameters GetNewExternalDBParameters(Durados.SqlProduct sqlProduct, string id, out string server, out int port, string sampleApp)//, out string catalog { // set all the database parameters for the createapp Durados.Web.Mvc.UI.Helpers.NewDatabaseParameters newDbParameters = new Durados.Web.Mvc.UI.Helpers.RDSNewDatabaseFactory().GetNewParameters(sqlProduct, id); //catalog = newDbParameters.DbName; CreateNewSchemaAndUser(sqlProduct, out server, out port, newDbParameters, sampleApp); //server = newDbParameters.InstanceName; //System.Configuration.ConfigurationManager.AppSettings["AWSServer"]??".";//aws database server //catalog = sqlProduct == Durados.SqlProduct.SqlServer ? newDbParameters.InstanceName : newDbParameters.DbName; return(newDbParameters); }
private static System.Data.Common.DbConnectionStringBuilder GetConnectionStringBuilder(Durados.SqlProduct product) { if (product == SqlProduct.MySql) { return(new MySql.Data.MySqlClient.MySqlConnectionStringBuilder()); } return(new System.Data.SqlClient.SqlConnectionStringBuilder()); }
public static string GetConnectionString(string server, string username, string password, bool isMaster = false, Durados.SqlProduct product = Durados.SqlProduct.SqlServer) { System.Data.Common.DbConnectionStringBuilder builder = GetConnectionStringBuilder(product); builder["data source"] = server; builder["User ID"] = username; builder["Password"] = password; if (isMaster) { builder["initial catalog"] = "master"; } return(builder.ConnectionString); }
public static System.Data.IDbConnection GetConnection(Durados.SqlProduct sqlProduct, string connectionString) { return(Durados.DataAccess.DataAccessObject.GetNewConnection(sqlProduct, connectionString)); }
public static string GetConnectionString(string serverName, string catalog, bool?integratedSecurity, string username, string password, string duradosuserId, Durados.SqlProduct sqlProduct, int localPort, bool usesSsh, bool usesSsl) { string connectionString = null; System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(); builder.ConnectionString = Maps.Instance.ConnectionString; bool hasServer = !string.IsNullOrEmpty(serverName); bool hasCatalog = !string.IsNullOrEmpty(catalog); if (!hasCatalog) { throw new Durados.DuradosException("Catalog Name is missing"); } if (integratedSecurity.HasValue && integratedSecurity.Value) { if (!hasServer) { serverName = builder.DataSource; } connectionString = "Data Source={0};Initial Catalog={1};Integrated Security=True;"; return(string.Format(connectionString, serverName, catalog)); } else { connectionString = "Data Source={0};Initial Catalog={1};User ID={2};Password={3};Integrated Security=False;"; if (sqlProduct == Durados.SqlProduct.MySql) { if (usesSsh) { connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};convert zero datetime=True"; } else { connectionString = "server={0};database={1};User Id={2};password={3};port={4};convert zero datetime=True"; } } if (sqlProduct == Durados.SqlProduct.Postgre) { if (usesSsl) { if (usesSsh) { connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};SSL=true;SslMode=Require;"; } else { connectionString = "server={0};database={1};User Id={2};password={3};port={4};SSL=true;SslMode=Require;"; } } else if (usesSsh) { connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};Encoding=UNICODE;"; } else { connectionString = "server={0};database={1};User Id={2};password={3};port={4};Encoding=UNICODE;"; } } if (sqlProduct == Durados.SqlProduct.Oracle) { connectionString = Durados.DataAccess.OracleAccess.GetConnectionStringSchema(); } bool hasUsername = !string.IsNullOrEmpty(username); bool hasPassword = !string.IsNullOrEmpty(password); if (!hasServer) { if (Maps.AllowLocalConnection) { serverName = builder.DataSource; } else { throw new Durados.DuradosException("Server Name is missing"); } } if (!hasUsername) { if (Maps.AllowLocalConnection) { username = builder.UserID; } else { throw new Durados.DuradosException("Username is missing"); } } if (!hasPassword) { if (Maps.AllowLocalConnection) { password = builder.Password; } else { throw new Durados.DuradosException("Password is missing"); } } return(string.Format(connectionString, serverName, catalog, username, password, localPort)); } }