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