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); }