16

        private static void RemoveTowns()
        {
            Console.Write("Enter town name: ");
            string townName = Console.ReadLine();

            using (var context = new SoftUniContext())
            {
                var affectedEmployees = context.Employees.Where(x => x.Address.Town.Name == townName);

                foreach (var e in affectedEmployees)
                {
                    e.AddressID = null;
                }
                var addresses = affectedEmployees.Select(x => x.Address);
                context.Addresses.RemoveRange(addresses);

                if (addresses.Count() > 0)
                {
                    var town = addresses.Select(x => x.Town).First();
                    context.Towns.Remove(town);
                }
                int deletedAddresses = addresses.Count();
                context.SaveChanges();

                if (deletedAddresses == 1)
                {
                    Console.WriteLine($"{deletedAddresses} address in {townName} was deleted");
                }
                else
                {
                    Console.WriteLine($"{deletedAddresses} addresses in {townName} were deleted");
                }
            }
        }