public override async Task <IReadOnlyCollection <UserReadModel> > ExecuteAsync(
GetAllUsersQuery query,
CancellationToken cancellationToken = default)
{
using (var connection = new NpgsqlConnection(_connectionString))
{
return((await connection.QueryAsync <UserReadModel>(Sql))
.ToList());
}
}
public override async Task <IReadOnlyCollection <UserReadModel> > ExecuteAsync(
GetAllUsersQuery query,
CancellationToken cancellationToken = default)
{
var cityDict = await GetCityDictionaryAsync();
await using var connection = new NpgsqlConnection(_connectionString);
var userList = (await connection.QueryAsync <UserReadModel>(Sql)).ToList();
foreach (var user in userList)
{
user.CityName = cityDict[user.CityId].Name;
user.DistrictName = cityDict[user.CityId].Districts.First(d => d.Id == user.DistrictId).Name;
}
return(userList);
}
