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);
            }
        }