public async Task <List <Table> > GetTablesAsync(TableSearch search)
{
string connectionString = GetConnectionString(search);
try
{
using (IDbConnection connection = new MySqlConnection(connectionString))
{
string sql = SQLProvider.GetTableSql(search.Database);
if (!string.IsNullOrEmpty(search.TableName))
{
sql += $" AND TABLE_NAME = '{search.TableName}' ";
}
var res = await connection.QueryAsync <Table>(sql);
return(res.ToList());
}
}
catch (System.Exception ex)
{
throw new System.Exception(ex.Message);
}
}