Beispiel #1
0
 /// <summary>
 /// SQLExeCute Finish output Log Exclude Reader
 /// </summary>
 /// <param name="profiledDbCommand"></param>
 /// <param name="executeType"></param>
 /// <param name="reader"></param>
 public void ExecuteFinish(IDbCommand profiledDbCommand, SqlExecuteType executeType, DbDataReader reader)
 {
     commandText = profiledDbCommand.CommandText.Replace('\r', ' ').Replace('\n', ' ').Replace('\t', ' ');
     parameters  = new StringBuilder();
     for (int ix = 0; ix < profiledDbCommand.Parameters.Count; ix++)
     {
         var parameter = (DbParameter)profiledDbCommand.Parameters[ix];
         parameters.Append($" [ParameterName={parameter.ParameterName} ,Value={parameter.Value.ToString()}]");
     }
     if (executeType != SqlExecuteType.Reader)
     {
         stopwatch.Stop();
         logger.Debug($"SQL = {commandText} {parameters.ToString()} ExecuteTime={stopwatch.Elapsed.ToString()}");
     }
 }