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

            driver.SelectBy_LocationId(fldLocationId
                                       );
            return(driver.Results);
        }
        /// <summary>
        /// Run Candidate_SelectBy_LocationId, and return results as a list of CandidateRow.
        /// </summary>
        /// <param name="fldLocationId">Value for LocationId</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_LocationIdNow(int fldLocationId
                                                                      , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateLogic();

            driver.SelectBy_LocationId(fldLocationId
                                       , connection, transaction);

            return(driver.Results);
        }