public override void WriteTo(SqlWriter writer) {
if (partitions.Count > 0) {
writer.WriteKeyword("PARTITION BY ");
writer.WriteScriptSequence(partitions, WhitespacePadding.None, w => w.Write(", "));
if (orders.Count > 0) {
writer.Write(' ');
}
}
if (orders.Count > 0) {
writer.WriteKeyword("ORDER BY ");
writer.WriteScriptSequence(orders, WhitespacePadding.None, w => w.Write(", "));
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("RAISERROR");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(arguments, WhitespacePadding.None, w => w.Write(", "));
}
writer.Write(')');
if (options.Count > 0) {
writer.WriteKeyword(" WITH ");
writer.WriteScriptSequence(options, WhitespacePadding.None, w => w.Write(", "));
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("FOR UPDATE");
if (columns.Count > 0) {
writer.WriteKeyword(" OF ");
writer.WriteScriptSequence(columns, WhitespacePadding.None, w => w.Write(", "));
}
}
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) {
WriteCommentsTo(writer);
writer.WriteKeyword("BEGIN TRY");
using (writer.Indent()) {
writer.WriteScriptSequence(tryStatements, WhitespacePadding.NewlineBefore, w => w.Write(';'));
writer.WriteLine(";");
}
writer.WriteKeyword("END TRY");
writer.WriteLine();
writer.WriteKeyword("BEGIN CATCH");
using (writer.Indent()) {
writer.WriteScriptSequence(catchStatements, WhitespacePadding.NewlineBefore, w => w.Write(';'));
writer.WriteLine(";");
}
writer.WriteKeyword("END CATCH");
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("OPTION ");
writer.Write('(');
writer.WriteScriptSequence(options, WhitespacePadding.None, w => w.Write(", "));
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('.'));
}
}
public AnyStatement(Identifier identifier, Sequence<Expression> expressions) {
using (StringWriter stringWriter = new StringWriter()) {
SqlWriter statementWriter = new SqlWriter(stringWriter, DatabaseEngine.Unknown);
statementWriter.WriteIdentifier(identifier.Value);
statementWriter.WriteScriptSequence(expressions, WhitespacePadding.SpaceBefore, null);
statementText = stringWriter.ToString();
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("INSERT ");
if (columnNames.Count > 0) {
writer.Write('(');
writer.WriteScriptSequence(columnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(") ");
}
if (expressions.Count > 0) {
writer.WriteKeyword("VALUES ");
writer.Write('(');
writer.WriteScriptSequence(expressions, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
} else {
writer.WriteKeyword("DEFAULT VALUES");
}
}
protected override void WriteToInternal(SqlWriter writer) {
if (columnNames.Count > 0) {
writer.Write(" (");
writer.WriteScriptSequence(columnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(")");
}
writer.WriteScript(output, WhitespacePadding.NewlineBefore);
}
public override void WriteTo(SqlWriter writer) {
if (HasValue) {
writer.WriteKeyword("WITH ");
writer.Write('(');
writer.WriteScriptSequence(hints, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
}
}
public override void WriteTo(SqlWriter writer) {
writer.Write('(');
using (writer.Indent()) {
writer.WriteScript(inner, WhitespacePadding.NewlineBefore);
writer.WriteScriptSequence(joins, WhitespacePadding.NewlineBefore, null);
}
writer.WriteLine();
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
if (HasValue) {
writer.WriteKeyword("OUTPUT ");
using (writer.Indent()) {
writer.WriteScriptSequence(columnItems, WhitespacePadding.None, w => w.Write(", "));
if (destinationName != null) {
writer.WriteLine();
writer.WriteKeyword("INTO ");
writer.WriteScript(destinationName, WhitespacePadding.None);
if (destinationColumnNames.Count > 0) {
writer.Write(" (");
writer.WriteScriptSequence(destinationColumnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
}
}
}
}
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("BEGIN");
writer.WriteLine();
using (writer.Indent()) {
writer.WriteScriptSequence(statements, WhitespacePadding.None, w => w.WriteLine(";"));
writer.WriteLine(";");
}
writer.WriteKeyword("END");
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
if (HasValue) {
writer.WriteKeyword("WITH ");
if (namespaces.Count > 0) {
using (writer.Indent()) {
writer.WriteKeyword("XMLNAMESPACES ");
writer.Write('(');
writer.WriteScriptSequence(namespaces, WhitespacePadding.NewlineBefore, w => w.Write(','));
}
writer.WriteLine();
writer.Write(')');
if (commonTableExpressions.Count > 0) {
writer.WriteLine(",");
}
}
writer.WriteScriptSequence(commonTableExpressions, WhitespacePadding.None, w => w.WriteLine(","));
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword(" TRIGGER ");
if (All) {
writer.WriteKeyword("ALL");
} else {
writer.WriteScriptSequence(triggerNames, WhitespacePadding.None, w => w.Write(", "));
}
writer.WriteKeyword(" ON ");
writer.WriteScript(target, WhitespacePadding.None);
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword("AS TABLE ");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(tableDefinitions, WhitespacePadding.NewlineBefore, w => w.Write(","));
}
writer.WriteLine();
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("DECLARE ");
writer.WriteScript(variableName, WhitespacePadding.None);
writer.WriteKeyword(" TABLE ");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(tableDefinitions, WhitespacePadding.NewlineBefore, w => w.Write(','));
}
writer.WriteLine();
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 void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.WriteKeyword(UniqueKindName);
writer.Write(' ');
writer.WriteEnum(clustered, WhitespacePadding.SpaceAfter);
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(indexColumns, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
writer.WriteScript(indexOptionGroup, WhitespacePadding.SpaceBefore);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteKeyword("FOR XML ");
writer.WriteKeyword(KindSpecifier);
if (elementName != null) {
writer.Write(" (");
writer.WriteScript(elementName, WhitespacePadding.None);
writer.Write(')');
}
if (directives.Count > 0) {
writer.Write(", ");
writer.WriteScriptSequence(directives, WhitespacePadding.None, w => w.Write(", "));
}
}
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) {
using (writer.Indent()) {
writer.Write('(');
writer.WriteKeyword("VALUES");
string separator = "";
foreach (IEnumerable<Expression> expressions in valuesList) {
writer.WriteLine(separator);
separator = ",";
writer.Write("(");
writer.WriteScriptSequence(expressions, WhitespacePadding.None, w => w.Write(", "));
writer.Write(")");
}
}
writer.WriteLine();
writer.Write(')');
base.WriteTo(writer);
}
protected override void WriteToInternal(SqlWriter writer) {
base.WriteToInternal(writer);
writer.WriteLine();
writer.WriteKeyword("VALUES");
using (writer.Indent()) {
string separator = "";
foreach (IEnumerable<Expression> expressions in valuesList) {
if (valuesList.Count > 1) {
writer.WriteLine(separator);
} else {
writer.Write(' ');
}
separator = ",";
writer.Write("(");
writer.WriteScriptSequence(expressions, WhitespacePadding.None, w => w.Write(", "));
writer.Write(")");
}
}
}
private void WriteToInternal(SqlWriter writer, string command) {
WriteCommentsTo(writer);
writer.WriteKeyword(command);
writer.WriteKeyword(" VIEW ");
writer.WriteScript(viewName, WhitespacePadding.None);
if (columnNames.Count > 0) {
writer.Write(" (");
writer.WriteScriptSequence(columnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
}
writer.WriteScript(viewOption, WhitespacePadding.SpaceBefore);
writer.WriteKeyword(" AS");
writer.WriteLine();
using (writer.Indent()) {
writer.WriteScript(selectStatement, WhitespacePadding.None);
if (withCheckOption) {
writer.WriteKeyword(" WITH CHECK OPTION");
}
}
}
public override void WriteTo(SqlWriter writer) {
base.WriteTo(writer);
writer.Write('(');
writer.WriteScriptSequence(columnNames, WhitespacePadding.None, w => w.Write(", "));
writer.Write(')');
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("CREATE ");
if (unique) {
writer.WriteKeyword("UNIQUE ");
}
writer.WriteEnum(clustered, WhitespacePadding.SpaceAfter);
writer.WriteKeyword("INDEX ");
writer.WriteScript(IndexName, WhitespacePadding.None);
writer.WriteKeyword(" ON ");
writer.WriteScript(TableName, WhitespacePadding.None);
writer.Write(" (");
using (writer.Indent()) {
writer.WriteScriptSequence(indexColumns, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
if (includeColumnNames.Count > 0) {
writer.WriteKeyword(" INCLUDE ");
writer.Write('(');
using (writer.Indent()) {
writer.WriteScriptSequence(includeColumnNames, WhitespacePadding.NewlineBefore, w => w.Write(", "));
}
writer.WriteLine();
writer.Write(')');
}
WhitespacePadding optionsPadding = WhitespacePadding.SpaceBefore;
if ((filter != null) && writer.IsAtLeast(DatabaseEngine.SqlServer2008)) {
writer.WriteLine();
writer.WriteKeyword("WHERE ");
using (writer.Indent()) {
writer.WriteScript(filter, WhitespacePadding.None, null, null);
}
optionsPadding = WhitespacePadding.NewlineBefore;
}
writer.WriteScript(IndexOptions, optionsPadding);
}
protected override void WriteToInternal(SqlWriter writer) {
writer.WriteScriptSequence(columns, WhitespacePadding.None, w => w.Write(", "));
}
public override void WriteTo(SqlWriter writer) {
WriteCommentsTo(writer);
writer.WriteKeyword("UPDATE SET ");
writer.WriteScriptSequence(updateItems, WhitespacePadding.None, w => w.Write(", "));
}
internal void WriteToWithoutSelect(SqlWriter writer) {
writer.WriteDuplicateRestriction(restriction, WhitespacePadding.SpaceAfter);
writer.WriteScript(top, WhitespacePadding.SpaceAfter);
using (writer.Indent()) {
writer.WriteScriptSequence(columnItems, WhitespacePadding.None, w => w.Write(", "));
}
writer.WriteScript(intoClause, WhitespacePadding.NewlineBefore, w => w.WriteKeyword("INTO "), null);
WriteToInternal(writer);
writer.WriteScript(forClause, WhitespacePadding.SpaceBefore);
writer.WriteScript(unionClause, WhitespacePadding.NewlineBefore);
}
