public async Task<List<Message>> GetMessages(long accountId, long folderId)
{
using (var sqlConnection = new MySqlConnection(_connectionString))
{
sqlConnection.Open();
var messages =
await
sqlConnection.QueryAsync<Message>(
"SELECT * FROM hm_messages WHERE messageaccountid = @messageaccountid AND messagefolderid = @messagefolderid",
new
{
messageaccountid = accountId,
messagefolderid = folderId
});
return messages.ToList();
}
}