public async Task <IEnumerable <SavingTypeDto> > HandleAsync(SavingTypeListQuery query,
CancellationToken cancellationToken = default(CancellationToken))
{
var types = await
_db.SavingTypes
.Where(e => e.UserId == query.UserId)
.Select(e =>
new SavingTypeDto
{
Id = e.Id,
Name = e.Name,
Symbol = e.Symbol,
Version = e.Version
}
).AsNoTracking().ToListAsync(cancellationToken);
return(types);
}
public async Task <IEnumerable <SavingTypeDto> > HandleAsync(SavingTypeListQuery query,
CancellationToken cancellationToken = default(CancellationToken))
{
using (var conn = new SqlConnection(_configuration.HouseholdConnectionString))
{
await conn.OpenAsync(cancellationToken);
var types = await conn.QueryAsync <SavingTypeDto>(@"
SELECT Id, Name, Symbol, Version
FROM SavingTypes
WHERE UserId = @UserId
",
new
{
query.UserId
});
return(types);
}
}
