@Override
  public Optional<ContestTeamMemberRole> get(Long id_) throws NotFoundException {

    final Record record =
        this.dslContext
            .selectFrom(CONTEST_TEAM_MEMBER_ROLE)
            .where(CONTEST_TEAM_MEMBER_ROLE.ID_.eq(id_))
            .fetchOne();

    if (record == null) {
      return Optional.empty();
    }
    return Optional.of(record.into(ContestTeamMemberRole.class));
  }