using System;

using Microsoft.Data.SqlClient;

/*Can you identify the logic issues specifically in the try-catch-finally block?

Explain what could go wrong at runtime and suggest how to fix it.

​

*/

public class Program

{

    public static void Main()

    {

     try

    {

        using (SqlConnection conn = new SqlConnection("Server=myserver;Database=mydb;User Id=admin;Password=secret;"))

        {

            conn.Open();

            Console.WriteLine("Connection opened.");

​

            using (SqlCommand cmd = new SqlCommand("SELECT * FROM Users", conn))

            using (SqlDataReader reader = cmd.ExecuteReader())

            {

                while (reader.Read())

                {

                    Console.WriteLine(reader["Name"].ToString());

                }

            }

​

            Console.WriteLine("Data fetch complete.");

        }

    }

    catch (Exception ex)

    {

        Console.WriteLine("Something went wrong: " + ex.Message);

    }

    }

}