private static void UpdateSkiRun() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); List <Firearm> firearms = firearmRepository.SelectAll(); Firearm firearm = new Firearm(); int firearmID; using (firearmRepository) { firearms = firearmRepository.SelectAll(); firearmID = ConsoleView.GetFirearmID(firearms); firearm = firearmRepository.SelectById(firearmID); firearm = ConsoleView.UpdateFirearm(firearm); firearmRepository.Update(firearm); } }