public static int Execute(string connectionName, string update, object param = null) { OutputLog(connectionName, update, param); using (var cn = new DbConnectionFactory(connectionName).Create()) { int result = 0; cn.Open(); using (var tr = cn.BeginTransaction()) { try { result = cn.Execute(update, param, tr); tr.Commit(); } catch { tr.Rollback(); } } return(result); } }