在c#紧凑框架中，如何在保持开放连接中的外键约束的同时执行SQLite事务？

using System.Data.SQLite;

// 创建连接对象
SQLiteConnection connection = new SQLiteConnection("Data Source=your_database_path");

// 打开连接
connection.Open();

// 开启事务
SQLiteTransaction transaction = connection.BeginTransaction();

// 设置外键约束为开启
SQLiteCommand pragmaCommand = new SQLiteCommand("PRAGMA foreign_keys = ON;", connection);
pragmaCommand.ExecuteNonQuery();

// 创建并执行SQL语句
SQLiteCommand command = new SQLiteCommand("INSERT INTO your_table (column1, column2) VALUES (@value1, @value2)", connection);
command.Parameters.AddWithValue("@value1", "some_value1");
command.Parameters.AddWithValue("@value2", "some_value2");
command.ExecuteNonQuery();

// 提交事务
transaction.Commit();

// 关闭连接
connection.Close();