对于记录详细的日志，xxx修改了某个字段，原来值是多少，新值是多少这种日志大家有什么高见

Question

对于记录详细的日志，xxx修改了某个字段，原来值是多少，新值是多少这种日志大家有什么高见

Answer 1

class EfIntercepterLogging : DbCommandInterceptor{private readonly Stopwatch _stopwatch = new Stopwatch();public override void ScalarExecuting(System.Data.Common.DbCommand command, DbCommandInterceptionContext<object> interceptionContext){base.ScalarExecuting(command, interceptionContext);_stopwatch.Restart();}public override void ScalarExecuted(System.Data.Common.DbCommand command, DbCommandInterceptionContext<object> interceptionContext){_stopwatch.Stop();if (interceptionContext.Exception != null){Trace.TraceError("Exception:{1} \r\n --> Error executing command: {0}", command.CommandText, interceptionContext.Exception.ToString());}else{Trace.TraceInformation("\r\n执行时间:{0} 毫秒\r\n-->ScalarExecuted.Command:{1}\r\n", _stopwatch.ElapsedMilliseconds, command.CommandText);}base.ScalarExecuted(command, interceptionContext);}一处地方，几句代码搞定。