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