/// <summary>
        /// Run ContentInspection_SelectAll, and return results as a list of ContentInspectionRow.
        /// </summary>

        /// <returns>A collection of ContentInspectionRow.</returns>
        public static List <ContentInspectionContract> SelectAllNow()
        {
            var driver = new ContentInspectionLogic();

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

            driver.ReadAll(reader);

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

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

            driver.SelectAll(connection, transaction);

            return(driver.Results);
        }
        /// <summary>
        /// Run ContentInspection_SelectBy_ConfirmedByUserId, and return results as a list of ContentInspectionRow.
        /// </summary>
        /// <param name="fldConfirmedByUserId">Value for ConfirmedByUserId</param>
        /// <returns>A collection of ContentInspectionRow.</returns>
        public static List <ContentInspectionContract> SelectBy_ConfirmedByUserIdNow(int fldConfirmedByUserId
                                                                                     )
        {
            var driver = new ContentInspectionLogic();

            driver.SelectBy_ConfirmedByUserId(fldConfirmedByUserId
                                              );
            return(driver.Results);
        }
        /// <summary>
        /// Run ContentInspection_Search, and return results as a list of ContentInspectionRow.
        /// </summary>
        /// <param name="fldSourceUrl">Value for SourceUrl</param>
        /// <returns>A collection of ContentInspectionRow.</returns>
        public static List <ContentInspectionContract> SearchNow(string fldSourceUrl
                                                                 )
        {
            var driver = new ContentInspectionLogic();

            driver.Search(fldSourceUrl
                          );
            return(driver.Results);
        }
        /// <summary>
        /// Run ContentInspection_SelectBy_ProposedByUserId, and return results as a list of ContentInspectionRow.
        /// </summary>
        /// <param name="fldProposedByUserId">Value for ProposedByUserId</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of ContentInspectionRow.</returns>
        public static List <ContentInspectionContract> SelectBy_ProposedByUserIdNow(int fldProposedByUserId
                                                                                    , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new ContentInspectionLogic();

            driver.SelectBy_ProposedByUserId(fldProposedByUserId
                                             , connection, transaction);

            return(driver.Results);
        }
        /// <summary>
        /// Run ContentInspection_Search, and return results as a list of ContentInspectionRow.
        /// </summary>
        /// <param name="fldSourceUrl">Value for SourceUrl</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of ContentInspectionRow.</returns>
        public static List <ContentInspectionContract> SearchNow(string fldSourceUrl
                                                                 , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new ContentInspectionLogic();

            driver.Search(fldSourceUrl
                          , connection, transaction);

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

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