using Microsoft.Data.SqlClient;

namespace SqlServerConnectTest
{
    internal class Program
    {
        static void Main(string[] args)
        {
            var builder = new SqlConnectionStringBuilder();
            builder.DataSource = "xxx";
            builder.InitialCatalog = "xxx";
            builder.UserID = "xxx";
            builder. Password = "xxx";
            builder.TrustServerCertificate = true;
            builder.ApplicationName = "Connection test";
            builder.ConnectTimeout = 30;
            builder.Encrypt = true;

            Console.WriteLine(builder.ConnectionString);

            using (var cn = new SqlConnection(builder.ConnectionString))
            {
                try
                {
                    var stopwatch = System.Diagnostics.Stopwatch.StartNew();
                    cn.Open();
                    stopwatch.Stop();
                    Console.WriteLine("Connection successful!");
                    Console.WriteLine($"Time taken to connect: {stopwatch.ElapsedMilliseconds} ms");
                }
                catch (SqlException ex)
                {
                    Console.WriteLine($"SQL Error: {ex.Message}");
                }
                catch (Exception ex)
                {
                    Console.WriteLine($"General Error: {ex.Message}");
                }
            }
        }
    }
}