private static void ListAllFirearms()
        {
            FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
            List <Firearm>       firearm;

            using (firearmRepository)
            {
                firearm = firearmRepository.SelectAll();
                ConsoleView.DisplayAllFirearms(firearm);
                ConsoleView.DisplayContinuePrompt();
            }
        }