/// <summary>
        /// Run CandidateMetaData_SelectAll, and return results as a list of CandidateMetaDataRow.
        /// </summary>

        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SelectAllNow()
        {
            var driver = new CandidateMetaDataLogic();

            driver.SelectAll();
            return(driver.Results);
        }
        /// <summary>
        /// Read all CandidateMetaData rows from the provided reader into the list structure of CandidateMetaDataRows
        /// </summary>
        /// <param name="reader">The result of running a sql command.</param>
        /// <returns>A populated CandidateMetaDataRows or an empty CandidateMetaDataRows if there are no results.</returns>
        public static List <CandidateMetaDataContract> ReadAllNow(SqlDataReader reader)
        {
            var driver = new CandidateMetaDataLogic();

            driver.ReadAll(reader);

            return(driver.Results);
        }
        /// <summary>
        /// Run CandidateMetaData_SelectAll, and return results as a list of CandidateMetaDataRow.
        /// </summary>

        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SelectAllNow(SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateMetaDataLogic();

            driver.SelectAll(connection, transaction);

            return(driver.Results);
        }
        /// <summary>
        /// Run CandidateMetaData_SelectBy_MetaDataId, and return results as a list of CandidateMetaDataRow.
        /// </summary>
        /// <param name="fldMetaDataId">Value for MetaDataId</param>
        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SelectBy_MetaDataIdNow(int fldMetaDataId
                                                                              )
        {
            var driver = new CandidateMetaDataLogic();

            driver.SelectBy_MetaDataId(fldMetaDataId
                                       );
            return(driver.Results);
        }
        /// <summary>
        /// Run CandidateMetaData_Search, and return results as a list of CandidateMetaDataRow.
        /// </summary>
        /// <param name="fldMetaDataValue">Value for MetaDataValue</param>
        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SearchNow(string fldMetaDataValue
                                                                 )
        {
            var driver = new CandidateMetaDataLogic();

            driver.Search(fldMetaDataValue
                          );
            return(driver.Results);
        }
        /// <summary>
        /// Run CandidateMetaData_SelectBy_MetaDataId, and return results as a list of CandidateMetaDataRow.
        /// </summary>
        /// <param name="fldMetaDataId">Value for MetaDataId</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SelectBy_MetaDataIdNow(int fldMetaDataId
                                                                              , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateMetaDataLogic();

            driver.SelectBy_MetaDataId(fldMetaDataId
                                       , connection, transaction);

            return(driver.Results);
        }
        /// <summary>
        /// Run CandidateMetaData_Search, and return results as a list of CandidateMetaDataRow.
        /// </summary>
        /// <param name="fldMetaDataValue">Value for MetaDataValue</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidateMetaDataRow.</returns>
        public static List <CandidateMetaDataContract> SearchNow(string fldMetaDataValue
                                                                 , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidateMetaDataLogic();

            driver.Search(fldMetaDataValue
                          , connection, transaction);

            return(driver.Results);
        }
        /// <summary>");
        /// Advance one, and read values into a CandidateMetaData
        /// </summary>
        /// <param name="reader">The result of running a sql command.</param>");
        /// <returns>A CandidateMetaData or null if there are no results.</returns>
        public static CandidateMetaDataContract ReadOneNow(SqlDataReader reader)
        {
            var driver = new CandidateMetaDataLogic();

            return(driver.ReadOne(reader) ? driver.Results[0] : null);
        }