private string FormatStoredProcEntry() { var fullFormat = "CALL {0} {1} -- @{2} ms {3}, {4} "; var strParams = LoggingExtensions.FormatSqlParameters(_command.Parameters, "{1}" /*Value only*/, ", ", maxValueLen: 50); var strRowCount = (RowCount < 0) ? string.Empty : Util.SafeFormat(", {0} row(s)", RowCount); var strDateTime = base.CreatedOn.ToString("[yyyy/MM/dd HH:mm:ss]"); var result = Util.SafeFormat(fullFormat, _command.CommandText, strParams, ExecutionTime, strRowCount, strDateTime); return(result); }
private string FormatStoredProcEntry() { if (string.IsNullOrWhiteSpace(_procCallFormat) || !_procCallFormat.Contains("{0}")) { _procCallFormat = "{0} {1}"; } var fullFormat = _procCallFormat + " -- @{2} ms {3}, {4} "; //exec time, row count, datetime var strParams = LoggingExtensions.FormatSqlParameters(_command.Parameters, "{1}" /*Value only*/, ", ", maxValueLen: 50); var strRowCount = (RowCount < 0) ? string.Empty : StringHelper.SafeFormat(", {0} row(s)", RowCount); var strDateTime = _dateTime.ToString("[yyyy/MM/dd HH:mm:ss]"); var result = StringHelper.SafeFormat(fullFormat, _command.CommandText, strParams, ExecutionTime, strRowCount, strDateTime); return(result); }
private string FormatSqlEntry() { const string fullFormat = "{0} \r\n{1} -- Time {2} ms{3}, {4} \r\n"; //sql, params, exec time, row count, datetime var fParams = string.Empty; if (_command.Parameters.Count > 0) { var strParams = LoggingExtensions.FormatSqlParameters(_command.Parameters, "{0}={1}", ", ", maxValueLen: 50); fParams = StringHelper.SafeFormat("-- Parameters: {0} \r\n", strParams); } var strRowCount = (RowCount < 0) ? string.Empty : StringHelper.SafeFormat("; {0} row(s)", RowCount); var strDateTime = _dateTime.ToString("[yyyy/MM/dd HH:mm:ss]"); var result = StringHelper.SafeFormat(fullFormat, _command.CommandText, fParams, ExecutionTime, strRowCount, strDateTime); return(result); }