public static long ExecuteScalarInt64(this System.Data.IDbCommand self, bool writeLog, string cmd, long defaultvalue, params object[] values) { if (cmd != null) { self.CommandText = cmd; } if (values != null && values.Length > 0) { self.Parameters.Clear(); foreach (var n in values) { self.AddParameter(n); } } using (writeLog ? new Logging.Timer(LOGTAG, "ExecuteScalarInt64", string.Format("ExecuteScalarInt64: {0}", self.GetPrintableCommandText())) : null) using (var rd = self.ExecuteReader()) if (rd.Read()) { return(ConvertValueToInt64(rd, 0, defaultvalue)); } return(defaultvalue); }
public static int ExecuteNonQuery(this System.Data.IDbCommand self, bool writeLog, string cmd, params object[] values) { if (cmd != null) { self.CommandText = cmd; } if (values != null && values.Length > 0) { self.Parameters.Clear(); foreach (var n in values) { self.AddParameter(n); } } using (writeLog ? new Logging.Timer(LOGTAG, "ExecuteNonQuery", string.Format("ExecuteNonQuery: {0}", self.GetPrintableCommandText())) : null) return(self.ExecuteNonQuery()); }
public static System.Data.IDataReader ExecuteReader(this System.Data.IDbCommand self, string cmd, params object[] values) { if (cmd != null) { self.CommandText = cmd; } if (values != null && values.Length > 0) { self.Parameters.Clear(); foreach (var n in values) { self.AddParameter(n); } } using (new Logging.Timer(LOGTAG, "ExcuteReader", string.Format("ExecuteReader: {0}", self.GetPrintableCommandText()))) return(self.ExecuteReader()); }