public async Task<Account> GetByNameAsync(string address)
{
using (var sqlConnection = new MySqlConnection(_connectionString))
{
sqlConnection.Open();
var accounts = await sqlConnection.QueryAsync<Account>("SELECT * FROM hm_accounts WHERE accountaddress = @accountaddress", new
{
accountaddress = address
});
var account = accounts.SingleOrDefault();
return account;
}
}