❔ Connecting to a local DB

Dapper v2.0.151
Microsoft.Extensions.Configuration.Abstractions 7.0.0
System.Data.SqlClient v4.8.5

Dapper v2.0.151
Microsoft.Extensions.Configuration.Abstractions 7.0.0
System.Data.SqlClient v4.8.5

// Define a minimal connection string
using System.Data;
using System.Data.SqlClient;
using Dapper;

string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=FretNautDB;Integrated Security=True;Connect Timeout=60;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False";

try
{
    // Attempt to create a SqlConnection
    using IDbConnection connection = new SqlConnection(connectionString);
    {
        // Open the connection
        connection.Open();

        // Check if the connection is open
        if (connection.State == System.Data.ConnectionState.Open)
        {
            Console.WriteLine("Connection successfully opened.");
        }
        else
        {
            Console.WriteLine("Connection could not be opened.");
        }
    }
}
catch (Exception ex)
{
    Console.WriteLine($"An error occurred: {ex.Message}");
}

Console.WriteLine("Press any key to exit...");
Console.ReadKey();

// Define a minimal connection string
using System.Data;
using System.Data.SqlClient;
using Dapper;

string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=FretNautDB;Integrated Security=True;Connect Timeout=60;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False";

try
{
    // Attempt to create a SqlConnection
    using IDbConnection connection = new SqlConnection(connectionString);
    {
        // Open the connection
        connection.Open();

        // Check if the connection is open
        if (connection.State == System.Data.ConnectionState.Open)
        {
            Console.WriteLine("Connection successfully opened.");
        }
        else
        {
            Console.WriteLine("Connection could not be opened.");
        }
    }
}
catch (Exception ex)
{
    Console.WriteLine($"An error occurred: {ex.Message}");
}

Console.WriteLine("Press any key to exit...");
Console.ReadKey();

System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'

System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'