protected virtual IDbConnection GetConnection(MapDataSet.durados_AppRow appRow) { if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection == null) { throw new DuradosException("Missing app connection"); } SqlPersistency persistency = new SqlPersistency(); System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(); persistency.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MapsConnectionString"].ConnectionString; int sqlProduct = appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.SqlProductId; string connectionString = persistency.GetConnection(appRow, builder).ToString(); int localPort = 0; if (sqlProduct == (int)SqlProduct.MySql) { if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.IsSshUsesNull() || !appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.SshUses) { localPort = 3306; } else { localPort = 11111; } } else if (sqlProduct == (int)SqlProduct.Postgre) { localPort = Convert.ToInt32(appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.ProductPort ?? "5432"); } else if (sqlProduct == (int)SqlProduct.Oracle) { localPort = Convert.ToInt32(appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.ProductPort ?? "1521"); } if (sqlProduct == 3) { connectionString = persistency.GetMySqlConnection(appRow, builder, localPort).ToString(); } else if (sqlProduct == 4) { connectionString = persistency.GetPostgreConnection(appRow, builder, localPort).ToString(); } else if (sqlProduct == 5) { connectionString = persistency.GetOracleConnection(appRow, builder, localPort).ToString(); } else { connectionString = persistency.GetSqlServerConnection(appRow, builder).ToString(); } return(SqlAccess.GetNewConnection((SqlProduct)sqlProduct, connectionString)); }
protected virtual IDbConnection GetSystemConnection(MapDataSet.durados_AppRow appRow) { if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection_System == null) { throw new DuradosException("Missing system connection"); } SqlPersistency persistency = new SqlPersistency(); System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(); persistency.SystemConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SystemMapsConnectionString"].ConnectionString; int systemSqlProduct = appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection_System.SqlProductId; string connectionString = persistency.GetSystemConnection(appRow, builder).ToString(); return(SqlAccess.GetNewConnection((SqlProduct)systemSqlProduct, connectionString)); }