SQL Data Connection String

SQL Connection String for Desktop applications C# and .NET

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // Basic Connection String
        // This connects to the SQL Server using a specified server address, database name, username, and password.
        string basicConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";

        // Trusted Connection (Integrated Security)
        // This connects to the SQL Server using Windows Authentication (integrated security).
        string trustedConnectionString = "Server=myServerAddress;Database=myDataBase;Integrated Security=True;";

        // Connecting to a Named Instance
        // This connects to a specific named instance of SQL Server.
        string namedInstanceConnectionString = "Server=myServerAddress\\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;";

        // Connecting with a Specific Port
        // This connects to the SQL Server using a specified port number.
        string portConnectionString = "Server=myServerAddress,myPortNumber;Database=myDataBase;User Id=myUsername;Password=myPassword;";

        // Connection with Connection Timeout
        // This specifies a timeout period (in seconds) for establishing the connection.
        string timeoutConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Connection Timeout=30;";

        // Encrypted Connection
        // This enables encryption for the connection to SQL Server.
        string encryptedConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Encrypt=True;";

        // Connection String with Multiple Active Result Sets (MARS) Enabled
        // This allows multiple active result sets to be used in a single connection.
        string marsConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;MultipleActiveResultSets=True;";

        // Asynchronous Processing Enabled
        // This enables asynchronous processing of commands.
        string asyncConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Asynchronous Processing=True;";

        // Connecting with Application Name
        // This specifies the application name to be used in the connection string.
        string appNameConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Application Name=MyAppName;";

        // Connection with Failover Partner (for Database Mirroring)
        // This specifies a failover partner server for database mirroring.
        string failoverPartnerConnectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Failover Partner=myMirrorServerAddress;";

        // Example of using a connection string
        // Here, the basic connection string is used to create a new SqlConnection object.
        using (SqlConnection connection = new SqlConnection(basicConnectionString))
        {
            try
            {
                // Attempt to open the connection.
                connection.Open();
                // If successful, print a success message.
                Console.WriteLine("Connection successful!");
            }
            catch (Exception ex)
            {
                // If an error occurs, print the error message.
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }
    }
}

Explanation of Each Line: