public string FormatSql(string commandText, List <SqlTimingParameter> parameters) { var sqlFormatter = new SqlServerFormatter(); string sqlFormat; try { sqlFormat = sqlFormatter.GetFormattedSql(commandText, parameters); } catch (IndexOutOfRangeException) { return(string.Format("Could not format SQL: {0} params {1}", commandText, parameters)); } var poorMansFormatter = new TSqlStandardFormatter(); var fullFormatter = new SqlFormattingManager(poorMansFormatter); return(fullFormatter.Format(sqlFormat)); }
private string GenerateOutput(SqlServerFormatter _formatter, SqlCommand _dbCommand, string _commandText) { var sqlParameters = _dbCommand.GetParameters(); return(_formatter.GetFormattedSql(_commandText, sqlParameters, _dbCommand)); }
private string GenerateOutput() { var sqlParameters = _dbCommand.GetParameters(); return(_formatter.GetFormattedSql(_commandText, sqlParameters, _dbCommand)); }
public void OnError(IDbCommand profiledDbCommand, SqlExecuteType executeType, Exception exception) { exception.Data["SQL"] = _sqlFormatter.GetFormattedSql(profiledDbCommand); }