private static void LoadConnections()
{
System.Configuration.ConnectionStringSettings systemConnection = System.Configuration.ConfigurationManager.ConnectionStrings["SystemMapsConnectionString"] ?? null;
System.Data.Common.DbConnectionStringBuilder csb;
if (MySqlAccess.IsMySqlConnectionString(systemConnection.ConnectionString))
{
csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(systemConnection.ConnectionString);
}
else
{
csb = new System.Data.SqlClient.SqlConnectionStringBuilder(systemConnection.ConnectionString);
}
if (!List.ContainsKey(csb["data source"].ToString()))
{
List.Add(csb["data source"].ToString(), systemConnection.ConnectionString);
}
//else
// List[cnnParameter.serverName]=new SqlServersManager(connectionString) ;
AddOnPremissDemoDb();
AddExternalInstances();
isLoaded = true;
}
public static SqlServerManager GetServerManager(string server)
{
if (!IsLoaded)
{
LoadConnections();
}
if (List == null || List.Count == 0 || !List.ContainsKey(server))
{
return(null);
}
if (MySqlAccess.IsMySqlConnectionString(List[server]))
{
return(new MysqlManager(List[server]));
}
return(new SqlServerManager(List[server]));
}
public static Durados.Data.IDataAccess GetDataAccess(string connectionstring)
{
if (string.IsNullOrEmpty(connectionstring))
{
return(null);
}
if (MySqlAccess.IsMySqlConnectionString(connectionstring))
{
return new MYSqlDataAccess()
{
ConnectionString = connectionstring
}
}
;
return(new MSSqlDataAccess()
{
ConnectionString = connectionstring
});
}
}
private IDataTableAccess GetDataTableAccess(Durados.View view)
{
if (view is Durados.Config.IConfigView)
{
return(new ConfigAccess());
}
else
if (OracleAccess.IsOracleConnectionString(view.ConnectionString))
{
return(new OracleAccess());
}
if (PostgreAccess.IsPostgreConnectionString(view.ConnectionString))
{
return(new PostgreAccess());
}
else if (MySqlAccess.IsMySqlConnectionString(view.ConnectionString))
{
return(new MySqlAccess());
}
else
{
return(new SqlAccess());
}
}
