/// <summary>
        /// Run Candidate_Search, and return results as a list of CandidateRow.
        /// </summary>
        /// <param name="fldCandidateName">Value for CandidateName</param>
        /// <returns>A collection of CandidateRow.</returns>
        public static List <CandidateContract> SearchNow(string fldCandidateName
                                                         )
        {
            var driver = new CandidateLogic();

            driver.Search(fldCandidateName
                          );
            return(driver.Results);
        }
        /// <summary>
        /// Run Candidate_Search, and return results as a list of CandidateRow.
        /// </summary>
        /// <param name="fldCandidateName">Value for CandidateName</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> SearchNow(string fldCandidateName
                                                         , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateLogic();

            driver.Search(fldCandidateName
                          , connection, transaction);

            return(driver.Results);
        }