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