/// <summary>
        /// Run Location_Search, and return results as a list of LocationRow.
        /// </summary>
        /// <param name="fldLocationName">Value for LocationName</param>
        /// <returns>A collection of LocationRow.</returns>
        public static List <LocationContract> SearchNow(string fldLocationName
                                                        )
        {
            var driver = new LocationLogic();

            driver.Search(fldLocationName
                          );
            return(driver.Results);
        }
        /// <summary>
        /// Run Location_Search, and return results as a list of LocationRow.
        /// </summary>
        /// <param name="fldLocationName">Value for LocationName</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of LocationRow.</returns>
        public static List <LocationContract> SearchNow(string fldLocationName
                                                        , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new LocationLogic();

            driver.Search(fldLocationName
                          , connection, transaction);

            return(driver.Results);
        }