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