public async Task <List <EmailDto> > Handle(GetAllEmailsQuery query, CancellationToken cancellationToken)
{
var connection = _sqlConnectionFactory.GetOpenConnection();
return((await connection.QueryAsync <EmailDto>(
"SELECT " +
$"[Email].[Id] AS [{nameof(EmailDto.Id)}], " +
$"[Email].[From] AS [{nameof(EmailDto.From)}], " +
$"[Email].[To] AS [{nameof(EmailDto.To)}], " +
$"[Email].[Subject] AS [{nameof(EmailDto.Subject)}], " +
$"[Email].[Content] AS [{nameof(EmailDto.Content)}], " +
$"[Email].[Date] AS [{nameof(EmailDto.Date)}] " +
"FROM [app].[Emails] AS [Email] " +
"ORDER BY [Email].[Date] DESC")).AsList());
}
public async Task <IEnumerable <Email> > Handle(GetAllEmailsQuery request, CancellationToken cancellationToken)
{
return(await _repository.GetAllEmails(cancellationToken));
}
public async Task <List <EmailDto> > Handle(GetAllEmailsQuery query, CancellationToken cancellationToken)
{
var connection = await _sqlConnectionFactory.GetOpenConnectionAsync();
return((await connection.QueryAsync <EmailDto>(
