C# 启动SQLite事务功能操作数据库

C# 启动事务功能插入记录至 SQLite数据库中。

public static int ExecuteNonQuery(string commandText, object[] paramList)
        {
            SQLiteConnection cn = new SQLiteConnection(connectString);
            IDbCommand cmd = cn.CreateCommand();
            cmd.CommandText = commandText;
            if (null!=paramList)
            {
                cmd.CommandText = string.Format(commandText, paramList);
            }

            if (cn.State == ConnectionState.Closed)
                cn.Open();
            DbTransaction trans = cn.BeginTransaction();
            try
            {
                int result = cmd.ExecuteNonQuery();
                trans.Commit();
                cmd.Dispose();
                trans.Dispose();
                cn.Close();
                return result;
            }
            catch (System.Exception ex)
            {
                trans.Rollback();
                throw new Exception(ex.Message);
            }  
        }