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