UltraLite.NET User's Guide
Understanding UltraLite Development
UltraLite provides transaction processing to ensure the correctness of the data in your database. A transaction is a logical unit of work: it is either all executed or none of it is executed.
By default, UltraLite.NET operates in autocommit mode, so that each insert, update, or delete is executed as a separate transaction. Once the operation is completed, the change is made to the database. If you set the Connection.AutoCommit property to false, you can use multi-statement transactions. For example, if your application transfers money between two accounts, either both the deduction from the source account and the addition to the destination account must be completed, or neither must be completed.
If AutoCommit is set to false, you must execute a Connection.Commit() statement to complete a transaction and make changes to your database permanent, or you must execute a Connection.Rollback() statement to cancel all the operations of a transaction.
For more information, see the ianywhere.Ultralite.Connection class in the API Reference, in the online books.