public virtual void DbDalcCommandExecuting(object sender, DbCommandEventArgs args) { if (!Enabled) { return; } try { cmdExecutingTime[args.Command.GetHashCode()] = DateTime.Now; Write(args.Command, FormatDbCommand(args.Command)); } catch (Exception ex) { Trace.Fail("Cannot write SQL command trace: " + ex.Message); } }
public virtual void DbDalcCommandExecuted(object sender, DbCommandEventArgs args) { if (!Enabled) { return; } try { // count execution time if (!cmdExecutingTime.ContainsKey(args.Command.GetHashCode())) { Write(args.Command, "Cannot calculate execution time - 'executing' event wasn't raised?!"); } else { DateTime executingTime = cmdExecutingTime[args.Command.GetHashCode()]; string cmdTimeMsg = String.Format("execution time: {0}", DateTime.Now.Subtract(executingTime)); Write(args.Command, cmdTimeMsg); } } catch (Exception ex) { Trace.Fail("Cannot write SQL command trace: " + ex.Message); } }