public ICollection <DataBase> List()
{
Table tb = new Table();
ICollection <DataBase> coleccion = null;
Connection c = new MysqlConecction();
IDbConnection cnn = c.Open();
try
{
var registro = SqlMapper.Query <DataBase>(cnn, "Server_GetDatabases", null, commandType: CommandType.StoredProcedure);
coleccion = (ICollection <DataBase>)registro;
foreach (var item in coleccion)
{
item.tables = tb.GetAll(item.name);
}
}
catch (Exception e)
{
}
finally
{
c.Close(cnn);
}
return(coleccion);
}
/// <summary>
/// Get name_column and data_type
/// </summary>
/// <param name="db"></param>
/// <param name="table"></param>
private void GetColumn(string db, string table)
{
Connection c = new MysqlConecction();
IDbConnection cnn = c.Open();
try
{
var registro = SqlMapper.Query <Element>(cnn, "Server_GetColumn", new { db = db, tb = table }, commandType: CommandType.StoredProcedure);
column = new Queue <Element>(registro);
columnBack = (List <Element>)registro;
}
catch (Exception e)
{
}
finally
{
c.Close(cnn);
}
}
public ICollection<DataBase> List()
{
Table tb = new Table();
ICollection<DataBase> coleccion= null;
Connection c = new MysqlConecction();
IDbConnection cnn = c.Open();
try
{
var registro = SqlMapper.Query<DataBase>(cnn, "Server_GetDatabases", null, commandType: CommandType.StoredProcedure);
coleccion = (ICollection<DataBase>)registro;
foreach (var item in coleccion)
{
item.tables = tb.GetAll(item.name);
}
}
catch (Exception e)
{
}
finally
{
c.Close(cnn);
}
return coleccion;
}
/// <summary>
/// Get name_column and data_type
/// </summary>
/// <param name="db"></param>
/// <param name="table"></param>
private void GetColumn(string db, string table)
{
Connection c = new MysqlConecction();
IDbConnection cnn = c.Open();
try
{
var registro = SqlMapper.Query<Element>(cnn, "Server_GetColumn", new { db = db, tb = table}, commandType: CommandType.StoredProcedure);
column = new Queue<Element>(registro);
columnBack = (List<Element>)registro;
}
catch (Exception e)
{
}
finally
{
c.Close(cnn);
}
}