/// <summary>
        /// Gets all the RelayDisciplineDTO's linked with the given RelayDTO
        /// </summary>
        /// <param name="relay"></param>
        /// <returns></returns>
        public List <RelayDisciplineDTO> Select(RelayDTO relay)
        {
            var cmd        = SelectStatement + " WHERE FK_R=@var0";
            var parameters = new List <string> {
                relay.Pk.ToString()
            };
            var relayDisciplines = ReadParamterized(cmd, parameters);

            relayDisciplines.ForEach(rd => rd.Relay = relay); // make sure the correct object reference is used
            return(relayDisciplines);
        }
        public RelayDisciplineDTO GetRelayDisciplineDto(int pk, RelayDTO relay, int fk_d, int position)
        {
            var disciplineHandler = new DisciplineHandler();
            var discipline        = disciplineHandler.Select(fk_d);

            return(new RelayDisciplineDTO
            {
                Pk = pk,
                FK_R = relay.Pk,
                FK_D = fk_d,
                Position = position,
                Relay = relay,
                Discipline = discipline
            });
        }