public async Task <List <TableColumn> > GetTableColumnsAsync(TableSearch search)
{
try
{
string connectionString = GetConnectionString(search);
using (IDbConnection connection = new MySqlConnection(connectionString))
{
string sql = SQLProvider.GetTableColumnsSql(search.Database, search.TableName);
var res = await connection.QueryAsync <TableColumn>(sql);
return(res.ToList());
}
}
catch (System.Exception ex)
{
throw new System.Exception(ex.Message);
}
}