在c#中为MS Access创建一个事务

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\your\\database.accdb";
OleDbConnection connection = new OleDbConnection(connectionString);

connection.Open();

OleDbTransaction transaction = connection.BeginTransaction();

OleDbCommand command = new OleDbCommand("INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)", connection, transaction);
command.Parameters.AddWithValue("@Value1", value1);
command.Parameters.AddWithValue("@Value2", value2);
command.ExecuteNonQuery();

transaction.Commit();

transaction.Rollback();

connection.Close();