/// <summary>
        /// Run Candidate_SelectBy_CandidateId, and return results as a list of CandidateRow.
        /// </summary>
        /// <param name="fldCandidateId">Value for CandidateId</param>
        /// <returns>A collection of CandidateRow.</returns>
        public static List <CandidateContract> SelectBy_CandidateIdNow(int fldCandidateId
                                                                       )
        {
            var driver = new CandidateLogic();

            driver.SelectBy_CandidateId(fldCandidateId
                                        );
            return(driver.Results);
        }
        /// <summary>
        /// Run Candidate_SelectBy_CandidateId, and return results as a list of CandidateRow.
        /// </summary>
        /// <param name="fldCandidateId">Value for CandidateId</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidateRow.</returns>
        public static List <CandidateContract> SelectBy_CandidateIdNow(int fldCandidateId
                                                                       , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateLogic();

            driver.SelectBy_CandidateId(fldCandidateId
                                        , connection, transaction);

            return(driver.Results);
        }