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