public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword("CHECK ");
writer.WriteScript(replication, WhitespacePadding.SpaceAfter);
writer.WriteScript(predicate, WhitespacePadding.None);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(tableNameQualified, WhitespacePadding.None);
writer.Write('.');
writer.WriteScript(columnName, WhitespacePadding.None);
writer.Write('.');
base.WriteTo(writer);
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword("REFERENCES ");
writer.WriteScript(tableName, WhitespacePadding.None);
writer.WriteScript(refColumnName, WhitespacePadding.SpaceBefore);
writer.WriteScriptSequence(keyActions, WhitespacePadding.SpaceBefore, null);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(serverName, WhitespacePadding.None, null, w => w.Write('.'));
writer.WriteScript(databaseName, WhitespacePadding.None, null, w => w.Write('.'));
writer.WriteScript(schemaName, WhitespacePadding.None, null, w => w.Write('.'));
writer.WriteScript(tableName, WhitespacePadding.None);
base.WriteTo(writer);
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(valueExpression, WhitespacePadding.None);
base.WriteTo(writer);
writer.WriteKeyword(" IN ");
writer.WriteScript(tuple, WhitespacePadding.None);
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(functionCall, WhitespacePadding.None);
writer.WriteKeyword(" OVER ");
writer.Write('(');
writer.WriteScript(rankingArguments, WhitespacePadding.None);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("DROP INDEX ");
writer.WriteScript(indexName, WhitespacePadding.None);
writer.WriteKeyword(" ON ");
writer.WriteScript(tableName, WhitespacePadding.None);
writer.WriteScript(indexOptions, WhitespacePadding.SpaceBefore);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("IDENTITY");
writer.Write('(');
writer.WriteScript(typeName, WhitespacePadding.None);
writer.WriteScript(seed, WhitespacePadding.None, w => w.Write(", "), null);
writer.WriteScript(increment, WhitespacePadding.None, w => w.Write(", "), null);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("EXTERNAL NAME ");
writer.WriteScript(assemblyName, WhitespacePadding.None);
writer.Write('.');
writer.WriteScript(className, WhitespacePadding.None);
writer.Write('.');
writer.WriteScript(methodName, WhitespacePadding.None);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteFunction("CAST");
writer.Write('(');
writer.WriteScript(expression, WhitespacePadding.None);
writer.WriteKeyword(" AS ");
writer.WriteScript(typeName, WhitespacePadding.None);
writer.Write(')');
}
public override sealed void WriteTo(SqlWriter writer) {
writer.WriteScript(parameterName, WhitespacePadding.SpaceAfter);
writer.WriteScript(parameterTypeName, WhitespacePadding.None);
WriteParameterQualifiers(writer);
if (readOnly) {
writer.WriteKeyword(" READONLY");
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(valueExpression, WhitespacePadding.None);
base.WriteTo(writer);
writer.WriteKeyword(" LIKE ");
writer.WriteScript(pattern, WhitespacePadding.None);
writer.WriteScript(escape, WhitespacePadding.None, w => w.WriteKeyword("ESCAPE "), null);
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.Write('(');
writer.WriteScript(firstExpression, WhitespacePadding.None);
writer.Write(", ");
writer.WriteScript(secondExpression, WhitespacePadding.None);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(key, WhitespacePadding.None);
writer.WriteScript(value, WhitespacePadding.SpaceBefore);
if (elementName != null) {
writer.Write('(');
writer.WriteScript(elementName, WhitespacePadding.None);
writer.Write(')');
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteIdentifier("CONVERT");
writer.Write('(');
writer.WriteScript(typeName, WhitespacePadding.None);
writer.Write(", ");
writer.WriteScript(valueExpression, WhitespacePadding.None);
writer.WriteScript(style, WhitespacePadding.None, w => w.Write(", "), null);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(queryOptions, WhitespacePadding.NewlineAfter);
writer.WriteKeyword("SELECT ");
using (writer.Indent()) {
selectQuery.WriteToWithoutSelect(writer);
writer.WriteScript(queryHint, WhitespacePadding.SpaceBefore);
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(valueExpression, WhitespacePadding.None);
base.WriteTo(writer);
writer.WriteOperator(" BETWEEN ");
writer.WriteScript(lowerBound, WhitespacePadding.None);
writer.WriteOperator(" AND ");
writer.WriteScript(upperBound, WhitespacePadding.None);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("IDENTITY");
if (seed != null) {
Debug.Assert(increment != null);
writer.Write(" (");
writer.WriteScript(seed, WhitespacePadding.None);
writer.Write(", ");
writer.WriteScript(increment, WhitespacePadding.None);
writer.Write(')');
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(keyword, WhitespacePadding.None);
writer.Write('(');
WriteColumnInternal(writer);
writer.Write(", ");
writer.WriteScript(query, WhitespacePadding.None);
writer.WriteScript(language, WhitespacePadding.None, w => {
w.Write(',');
w.WriteKeyword(" LANGUAGE ");
}, null);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("FETCH ");
writer.WriteScript(cursorPosition, WhitespacePadding.SpaceAfter);
writer.WriteScript(cursorName, WhitespacePadding.None);
if (destinationVariables.Count > 0) {
using (writer.Indent()) {
writer.WriteLine();
writer.WriteKeyword("INTO ");
writer.WriteScriptSequence(destinationVariables, WhitespacePadding.None, w => w.Write(", "));
}
}
}
public override sealed void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteScript(queryOptions, WhitespacePadding.NewlineAfter);
writer.WriteKeyword("INSERT ");
using (writer.Indent()) {
writer.WriteScript(topExpression, WhitespacePadding.SpaceAfter);
writer.WriteLine();
writer.WriteKeyword("INTO ");
writer.WriteScript(destinationRowset, WhitespacePadding.None);
WriteToInternal(writer);
writer.WriteScript(QueryHint, WhitespacePadding.NewlineBefore);
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteScript(aliasName, WhitespacePadding.None);
if (columnNames.Count > 0) {
writer.Write(" (");
writer.WriteScriptSequence(columnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
}
writer.WriteKeyword(" AS ");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScript(selectQuery, WhitespacePadding.NewlineBefore);
}
writer.WriteLine();
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("IF ");
using (writer.Indent()) {
writer.WriteScript(condition, WhitespacePadding.SpaceAfter);
}
if (thenStatement is StatementBlock) {
writer.WriteScript(thenStatement, WhitespacePadding.None);
} else {
using (writer.Indent()) {
writer.WriteScript(thenStatement, WhitespacePadding.NewlineBefore);
}
}
writer.WriteScript(elseStatement, WhitespacePadding.None, w => w.WriteKeyword(" ELSE "), null);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteFunction("COUNT");
writer.Write('(');
writer.WriteDuplicateRestriction(restriction, WhitespacePadding.SpaceAfter);
writer.WriteScript(expression, WhitespacePadding.None);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteFunction("UPDATE");
writer.Write('(');
writer.WriteScript(columnName, WhitespacePadding.None);
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword("DEFAULT ");
writer.Write('(');
writer.WriteScript(defaultValue, WhitespacePadding.None);
writer.Write(')');
}
protected virtual void WriteToInternal(SqlWriter writer) {
writer.WriteScript(function, WhitespacePadding.None);
if (functions.Count > 0) {
writer.Write('.');
writer.WriteScriptSequence(functions, WhitespacePadding.None, w => w.Write('.'));
}
}
protected override void WriteArguments(SqlWriter writer) {
if (isMax) {
writer.WriteKeyword("MAX");
} else {
writer.WriteScript(extension, WhitespacePadding.None);
}
}
public override void WriteTo(SqlWriter writer) {
// we ignore the fill factor when computing a hash, so that differences due to fill factor only are ignored
if (writer.Mode != SqlWriterMode.ForHashing) {
writer.WriteKeyword("WITH FILLFACTOR");
writer.Write('=');
writer.WriteScript(fillfactor, WhitespacePadding.None);
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.Write('(');
using (writer.Indent()) {
writer.WriteScript(expression, WhitespacePadding.None);
}
writer.Write(')');
}
