public List <AddressEntity> Execute()
        {
            var command   = new NpgsqlCommand(Sql, _dataSource.DbConnection);
            var resultSet = command.ExecuteReader();

            var result = _rowMapper.FromResultSet(resultSet);

            _dataSource.CloseDbConnection();

            return(result);
        }
        public AddressEntity Execute()
        {
            var command = new NpgsqlCommand(Sql, _dataSource.DbConnection);

            command.Parameters.AddWithValue("Id", (long)_queryParamId);
            command.Prepare();

            var resultSet = command.ExecuteReader();
            var result    = _rowMapper.FromResultSet(resultSet).FirstOrDefault();

            _dataSource.CloseDbConnection();

            return(result);
        }