// NHibernate configuration
System.Collections.Generic.Dictionary<string, string> additionalProperties = new System.Collections.Generic.Dictionary<string, string>
{
    { "connection.provider", "NHibernate.Connection.DriverConnectionProvider" },
    { "dialect", "NHibernate.Dialect.SQLiteDialect" },
    { "connection.driver_class", "NHibernate.Driver.SQLite20Driver" },
    { "connection.connection_string", connectionString },
    { "show_sql", "true" },
    { "use_outer_join", "true" }
};

// SQLite connection and table creation
using (SQLiteConnection sQLiteConnection = new SQLiteConnection($"Data Source={distFileName};Password=4pqL69gzrGDMiDb1bKIxRUuh/hb1C1gXbfKUoZ64;BinaryGuid=False;"))
{
    sQLiteConnection.Open();
                        using (SQLiteCommand createTableCmd = new SQLiteCommand(
                                   "CREATE TABLE IF NOT EXISTS MyTable (Id INTEGER PRIMARY KEY, Name TEXT, Age INTEGER);",
                                   sQLiteConnection))
                        {
                            createTableCmd.ExecuteNonQuery();
                        }

                        using (SQLiteCommand insertDataCmd = new SQLiteCommand(
                                   "INSERT INTO MyTable (Name, Age) VALUES ('Alice', 30), ('Bob', 25), ('Charlie', 35);",
                                   sQLiteConnection))
                        {
                            insertDataCmd.ExecuteNonQuery();
                        }

                        sQLiteConnection.Close();
}

I expected the data to be inserted into the SQLite database without any authorization issues.

Attempts to Solve:

I’ve checked the database file permissions and verified the connection string. I’ve also tried using a different approach for inserting data but still encounter the same error.