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); } }