Database component Hxj.data (17) (transaction)

The transaction is upgraded first, so you'll have to download the new version again.

Components provide a simple transaction and do not have too many packages.

Let's start with the previous example:

using　(DbTrans　trans　=　DbSession.Default.BeginTransaction())
{
　　 DbSession.Default.Update<Products>(Products._.ProductName,　"apple",　Products._.ProductID　==　1,　trans);
　　 DbSession.Default.Update<Products>(Products._.ProductName,　"egg",　Products._.ProductID　==　2,　trans);
　　 trans.Commit();
}

Trans.commit (); Must be submitted, or the execution will not succeed.

If you use try catch with the following wording:

DbTrans　trans　=　DbSession.Default.BeginTransaction();
try
{
　　 DbSession.Default.Update<Products>(Products._.ProductName,　"apple",　Products._.ProductID　==　1,　trans);
　　 DbSession.Default.Update<Products>(Products._.ProductName,　"egg",　Products._.ProductID　==　2,　trans);
　　 trans.Commit();
}
catch
{
　　 trans.Rollback();
}
finally
{
　　 trans.Close();
}

The INSERT, update, and Delete methods all provide dbtransaction parameters

So also just add, modify, delete can commit the transaction.

stored procedures and direct SQL execution can also add transactions.

For example:

DbTrans　trans　=　DbSession.Default.BeginTransaction();
DbSession.Default.FromProc("Ten　Most　Expensive　Products").SetDbTransaction(trans);

Add a transaction through the Setdbtransaction method.

The same is true of Fromsql.

You can also set the level of the transaction as follows:

Dbtrans trans = DbSession.Default.BeginTransaction (isolationlevel.readcommitted);

In general, the components of the transaction package is relatively simple, it does not appear to be particularly convenient to write, pending further improvement.

In the use of the process feel inconvenient or need to improve the hope that we can put forward, thank you.

The following section describes the batch process.