1.
using (IDbConnection dbConnection =MySqlDBConnection.CreateMySqlConnection())
{
IDbTransaction tran = dbConnection.BeginTransaction();
try
{
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
throw;
}
finally
{
if (dbConnection.State == System.Data.ConnectionState.Open)
{
dbConnection.Close();
}
tran.Dispose();
}
}