8. IncreaseMinionsAge

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace IncreaseMinionsAge
{
    class IncreaseMinionsAge
    {
        static void Main(string[] args)
        {
            Console.Write("Enter Ids separated by space: ");
            List<int> minionIds = Console.ReadLine().Split().Select(int.Parse).ToList();

            SqlConnection connection = new SqlConnection(@"
                                    Server=.\SQLEXPRESS;" +
                                    "Database=MinionsDB;" +
                                    "Integrated Security=true");


            connection.Open();

            using (connection)
            {
                string updateQuery = $@"UPDATE Minions
                                       SET Age = Age + 1, Name = LOWER(Name)
                                       WHERE Id IN ({string.Join(", ", minionIds)})";

                SqlCommand updateCmd = new SqlCommand(updateQuery, connection);

                updateCmd.ExecuteNonQuery();


                string resultQuery = $@"SELECT m.Name, m.Age FROM Minions AS m WHERE m.Id IN ({string.Join(", ", minionIds)})";
                SqlCommand getResultsCmd = new SqlCommand(resultQuery, connection);

                SqlDataReader reader = getResultsCmd.ExecuteReader();


                Console.WriteLine(" Minion name | Age ");
                Console.WriteLine("-------------|-----");
                while (reader.Read())
                {
                    Console.WriteLine($"{reader[0], 12} |{reader[1], 3}");
                }
            }
        }
    }
}