create a transaction for MS Access in c#

Question

I need some code in my c# application to implement a transaction using Microsoft Access database

Answer 1

OleDbTransaction class is made just for that. You can create one by calling BeginTransaction on your OleDbConnection object then Commit or Rollback up to your scenario

using (var transaction = cn.BeginTransaction()) {
  //Do Stuff here using the connection
  transaction.Commit();
}

The transaction will be rolled back at dispose if no commit has been called.