How to add log messages and log them only when an exception occurs?

Question

I have a business process that executes a bunch of SQL commands. I want to "stack" these sql commands on the stack and write them to the DB only when an exception occurs, let me explain this with some code

public void BusinessMethod()
{
    Log.Initialize(); // Clear the stack
    try
    {  
        Method1ThatExecutesSomeSQLs();
        Method2ThatExecutesSomeSQLs();
        Method3ThatExecutesSomeSQLs();
    }
    catch(Expection ex)
    {
        // if some exception occured in any Method above, them i write the log, otherwise, i dont want to log anything
        Log.Write();
    }
} 

//Example of some Method that executes SQL's
public void Method1ThatExecutesSomeSQLs()
{
    string sql = "select * from table";
    ExecuteSQL(sql);
    Log.StackUp("The following sql command was executed: " + sql); //Just stack up, dont write!
}

Does anyone know if Log4Net or NLog supports this scenario? If not, how to implement it?

Answer 1

NLog 4.5 supports the script out of the box (currently in BETA). This will show the last 50 messages when a warning / error / fatal (Reason for starting auto-thread) occurs:

<target name="consoleWarn" xsi:type="AutoFlushWrapper" condition="level >= LogLevel.Warn" >
        <target xsi:type="BufferingWrapper" overflowAction="Discard" bufferSize="50">
             <target xsi:type="Console" layout="${level}:${message}" />
        </target>
</target>

NLog 4.4 ( ) , BufferingWrapper overflowAction. AsyncWrapper:

<target name="consoleWarn" xsi:type="AutoFlushWrapper" condition="level >= LogLevel.Warn" >
        <target xsi:type="BufferingWrapper" bufferSize="500">
             <target xsi:type="AsyncWrapper" queueLimit="50" overflowAction="Discard" fullBatchSizeWriteLimit="1" timeToSleepBetweenBatches="2000000000">
                <target xsi:type="Console" layout="${level}:${message}" />
             </target>
        </target>
</target>

. https://github.com/NLog/NLog.Extensions.Logging/issues/127

Answer 2

, MemoryTarget, (Flushing). :

public class Program
{
    private static Logger logger = LogManager.GetCurrentClassLogger();

    static void Main(string[] args)
    {
        try
        {
            logger.Log(LogLevel.Error, "Start of the process");
            // Inside Business class i have a lot of other logger.log() calls
            // Inside the business class a have a lot of DAOs that calls logger.log()
            // In ither words, all the calls to logger.log() will be stacked up
            Business b = new Business();
            b.DoSomethig();
            logger.Debug("End of the Process.");
        }
        catch (Exception )
        {
            var target = (MemoryTarget)LogManager.Configuration.FindTargetByName("MemoTarget");
            var logs = target.Logs;

            // Get all the logs in the "stack" of log messages
            foreach (string s in target.Logs)
            {
                Console.Write("logged: {0}", s);
            }
        }

    }
}

nlog.config:

<targets>
    <target xsi:type="Memory" name="MemoTarget" layout="${date:format=dd-MM-yyyy HH\:mm\:ss} | ${callsite} | ${message}" />
 ...
</targets>
...
<rules>
    <logger name="*" minlevel="Debug" writeTo="MemoTarget" />
</rules>
....

:

logged: 30-10-2017 20:12:36 | NLog_Tests.Program.Main | Start of the process 
logged: 30-10-2017 20:12:36 | NLog_Tests.Business.DoSomethig | Some business rule was executed
logged: 30-10-2017 20:12:36 | NLog_Tests.DAOClass.ExecuteCommand | some sql was executed
logged: 30-10-2017 20:12:36 | NLog_Tests.Program.Main | End of the Process.

Answer 3

, () :

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <targets async="true">
    <wrapper-target xsi:type="BufferingWrapper" name="buffer" bufferSize="32" flushTimeout="100">
      <wrapper-target xsi:type="PostFilteringWrapper">
        <defaultFilter>level >= LogLevel.Warn</defaultFilter>
        <when exists="level >= LogLevel.Error" filter="level >= LogLevel.Trace" />
        <target xsi:type="ColoredConsole" />
      </wrapper-target>
    </wrapper-target>
  </targets>
  <rules>
    <logger name="*" minlevel="Trace" writeTo="buffer" />
  </rules>
</nlog>

(max = 32) . , .

C # Test code with the above configuration. Only a warning will be visible. If an error or fatal message is added, all messages will be visible.

LogManager.Configuration = new XmlLoggingConfiguration(@"cfg\NLog.xml", false);
LogManager.ReconfigExistingLoggers();

LOG.Trace("trace");
LOG.Debug("debug");
LOG.Info("info");
LOG.Warn("warn");
//LOG.Error("error");
//LOG.Fatal("fatal");

LogManager.Flush();
LogManager.Shutdown();