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) { WriteCommentsTo(writer); writer.WriteScript(valueExpression, WhitespacePadding.None); writer.WriteKeyword(" IS"); base.WriteTo(writer); writer.WriteKeyword(" NULL"); }
public override sealed void WriteTo(SqlWriter writer) { if (position != CursorPosition.None) { writer.WriteKeyword(position.ToString().ToUpperInvariant()); writer.Write(' '); } WriteOffset(writer); writer.WriteKeyword("FROM"); }
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) { if (HasValue) { writer.WriteKeyword("USING XML INDEX "); writer.WriteScript(indexName, WhitespacePadding.None); writer.WriteLine(); writer.WriteKeyword("FOR "); writer.Write(IndexForSpecifier); } }
protected override void WriteParameterQualifiers(SqlWriter writer) { if (varying) { writer.WriteKeyword(" VARYING"); } base.WriteParameterQualifiers(writer); if (output) { writer.WriteKeyword(" OUTPUT"); } }
protected virtual void WriteMatchedTo(SqlWriter writer) { if (string.IsNullOrEmpty(NotMatchedBy)) { writer.WriteKeyword("MATCHED"); } else { writer.WriteKeyword("NOT MATCHED BY "); writer.WriteKeyword(NotMatchedBy); } writer.WriteScript(predicate, WhitespacePadding.None, w => w.WriteOperator(" AND "), null); }
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 sealed void WriteTo(SqlWriter writer) { WriteCommentsTo(writer); writer.WriteKeyword("WHEN "); using (writer.Indent()) { WriteMatchedTo(writer); writer.WriteKeyword(" THEN"); writer.WriteLine(); writer.WriteScript(operation, WhitespacePadding.None); } }
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.WriteEnum(tableCheck, WhitespacePadding.SpaceAfter); WriteCheckOperation(writer); writer.WriteKeyword(" CONSTRAINT "); if (constraintName != null) { writer.WriteScript(constraintName, WhitespacePadding.None); } else { writer.WriteKeyword("ALL"); } }
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) { 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) { 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 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.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) { 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) { if (HasValue) { writer.WriteKeyword("TOP "); writer.Write('('); writer.WriteScript(expression, WhitespacePadding.None); writer.Write(')'); if (percent) { writer.WriteKeyword(" PERCENT"); } if (withTies) { writer.WriteKeyword(" WITH TIES"); } } }
protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) { Debug.Assert(!isPartOfQualifiedName); if (global) { writer.WriteKeyword("GLOBAL "); } WriteNonGlobalInternal(writer); }
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) { base.WriteTo(writer); writer.WriteKeyword("DEFAULT "); writer.Write('('); writer.WriteScript(defaultValue, WhitespacePadding.None); writer.Write(')'); }
public override void WriteTo(SqlWriter writer) { WriteCommentsTo(writer); writer.WriteKeyword("CREATE XML SCHEMA COLLECTION "); writer.WriteScript(xmlSchemaCollectionName, WhitespacePadding.None); writer.WriteKeyword(" AS "); writer.WriteScript(expression, WhitespacePadding.None); }
public override void WriteTo(SqlWriter writer) { WriteCommentsTo(writer); writer.WriteKeyword("OPTION "); writer.Write('('); writer.WriteScriptSequence(options, WhitespacePadding.None, w => w.Write(", ")); writer.Write(')'); }
protected override void WriteArguments(SqlWriter writer) { if (isMax) { writer.WriteKeyword("MAX"); } else { writer.WriteScript(extension, WhitespacePadding.None); } }
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) { base.WriteTo(writer); writer.WriteKeyword("REFERENCES "); writer.WriteScript(tableName, WhitespacePadding.None); writer.WriteScript(refColumnName, WhitespacePadding.SpaceBefore); writer.WriteScriptSequence(keyActions, WhitespacePadding.SpaceBefore, null); }
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) { 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.WriteFunction("CAST"); writer.Write('('); writer.WriteScript(expression, WhitespacePadding.None); writer.WriteKeyword(" AS "); writer.WriteScript(typeName, WhitespacePadding.None); writer.Write(')'); }
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(')'); }
/// <summary> /// Writes the specified result set limitation for the current SQL dialect. /// Writes the <c>LIMIT <paramref name="offset"/>, <paramref name="count"/></c> clause /// to the output <paramref name="writer"/>. /// syntax. /// </summary> /// <param name="writer"> /// The <see cref="SqlWriter"/> to write to. /// </param> /// <param name="offset"> /// The row offset at which to start. /// </param> /// <param name="count"> /// The number of rows to fetch. /// </param> public override void WriteLimit(SqlWriter writer, int?offset, int?count) { writer.WriteKeyword(MySqlKeywords.Limit); if (offset != null) { writer.WriteValue(offset.GetValueOrDefault()); writer.WriteRaw(","); } writer.WriteValue(count.GetValueOrDefault(int.MaxValue)); }
/// <summary> /// Writes the specified result set limitation for the current SQL dialect. The default /// implementation uses the <c>OFFSET <paramref name="offset"/> ROWS FETCH FIRST <paramref name="count"/> ROWS ONLY</c> /// syntax. /// </summary> /// <param name="writer"> /// The <see cref="SqlWriter"/> to write to. /// </param> /// <param name="offset"> /// The row offset at which to start. /// </param> /// <param name="count"> /// The number of rows to fetch. /// </param> public virtual void WriteLimit(SqlWriter writer, int?offset, int?count) { if (offset != null) { writer.WriteKeyword(SqlKeywords.Offset); writer.WriteValue(offset.Value); writer.WriteKeyword(SqlKeywords.Rows); } if (count != null) { writer.WriteKeyword(SqlKeywords.Fetch); writer.WriteKeyword(SqlKeywords.First); writer.WriteValue(count.Value); writer.WriteKeyword(SqlKeywords.Rows); writer.WriteKeyword(SqlKeywords.Only); } }
public override void Visit(SqlGroupBy expression) { _writer.WriteKeyword(SqlKeywords.GroupBy); }