public static void LogCommand(StoreLogLevel level, string from, MySqlCommand cmd, Exception error)
{
if (level == StoreLogLevel.None)
{
return;
}
if (!App.Available)
{
return;
}
MessageType mt = level == StoreLogLevel.Debug ? MessageType.DebugSQL : MessageType.TraceSQL;
var descr = new StringBuilder(512);
descr.Append("Transaction: ");
if (cmd.Transaction == null)
{
descr.AppendLine("null");
}
else
{
descr.AppendLine(cmd.Transaction.IsolationLevel.ToString());
}
foreach (var p in cmd.Parameters.Cast <MySqlParameter>())
{
descr.AppendFormat("Parameter {0} = {1}", p.ParameterName, p.Value != null?p.Value.ToString():"null");
}
var msg = new Message
{
Type = mt,
From = from,
Topic = "DataStore",
Exception = error,
Text = cmd.CommandText,
Parameters = descr.ToString()
};
App.Log.Write(msg);
}
public static void LogCommand(StoreLogLevel level, string from, MySqlCommand cmd, Exception error)
{
if (level==StoreLogLevel.None) return;
if (!App.Available) return;
MessageType mt = level==StoreLogLevel.Debug ? MessageType.DebugSQL : MessageType.TraceSQL;
var descr = new StringBuilder(512);
descr.Append("Transaction: ");
if (cmd.Transaction==null)
descr.AppendLine("null");
else
descr.AppendLine(cmd.Transaction.IsolationLevel.ToString());
foreach(var p in cmd.Parameters.Cast<MySqlParameter>())
{
descr.AppendFormat("Parameter {0} = {1}", p.ParameterName, p.Value!=null?p.Value.ToString():"null");
}
var msg = new Message
{
Type = mt,
From = from,
Topic = "DataStore",
Exception = error,
Text = cmd.CommandText,
Parameters = descr.ToString()
};
App.Log.Write( msg );
}
