public async Task <IEnumerable <HouseholdDto> > HandleAsync(HouseholdListQuery query,
CancellationToken cancellationToken = default(CancellationToken))
{
using (var conn = new SqlConnection(_configuration.HouseholdConnectionString))
{
await conn.OpenAsync(cancellationToken);
var households = await conn.QueryAsync <HouseholdDto>(@"
SELECT Id, Name, Symbol, Description,
Address_Street AS Street, Address_City AS City, Address_Country AS Country, Address_ZipCode AS ZipCode,
Version
FROM Households
WHERE UserId = @UserId
",
new
{
query.UserId
});
return(households);
}
}
public async Task <IEnumerable <HouseholdDto> > HandleAsync(HouseholdListQuery query,
CancellationToken cancellationToken = default(CancellationToken))
{
var housesolds = await
_db.Households
.Where(e => e.UserId == query.UserId)
.Select(e =>
new HouseholdDto
{
Id = e.Id,
City = e.Address.City,
Country = e.Address.Country,
Description = e.Description,
Name = e.Name,
Street = e.Address.Street,
Symbol = e.Symbol,
ZipCode = e.Address.ZipCode,
Version = e.Version
}
).AsNoTracking().ToListAsync(cancellationToken);
return(housesolds);
}
