我有一个执行一堆SQL命令的业务流程。我想把这些SQL命令“堆叠”在一个栈里,并在出现异常时将它们写入DB。让我通过一些代码来解释。
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!
}
有人知道Log4Net或NLog是否支持这种情况吗?如果不支持,应该如何实现?