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>(