UpdateSqlGenerator Class

Definition

A base class for the IUpdateSqlGenerator service that is typically inherited from by database providers.

This type is typically used by database providers; it is generally not used in application code.

The service lifetime is Singleton. This means a single instance is used by many DbContext instances. The implementation must be thread-safe. This service cannot depend on services registered as Scoped.

public abstract class UpdateSqlGenerator : Microsoft.EntityFrameworkCore.Update.IUpdateSqlGenerator
type UpdateSqlGenerator = class
    interface IUpdateSqlGenerator
Public MustInherit Class UpdateSqlGenerator
Implements IUpdateSqlGenerator
Inheritance
UpdateSqlGenerator
Implements

Constructors

UpdateSqlGenerator(ISqlGenerationHelper)
UpdateSqlGenerator(UpdateSqlGeneratorDependencies)

Initializes a new instance of the this class.

Properties

Dependencies

Parameter object containing service dependencies.

SqlGenerationHelper

Helpers for generating update SQL.

Methods

AppendBatchHeader(StringBuilder)

Appends SQL text that defines the start of a batch.

AppendDeleteCommand(StringBuilder, String, String, IReadOnlyList<ColumnModification>)

Appends a SQL command for deleting a row to the commands being built.

AppendDeleteCommandHeader(StringBuilder, String, String)

Appends a SQL fragment for starting an DELETE.

AppendDeleteOperation(StringBuilder, ModificationCommand, Int32)

Appends a SQL command for deleting a row to the commands being built.

AppendFromClause(StringBuilder, String, String)

Appends a SQL fragment for starting an FROM clause.

AppendIdentityWhereCondition(StringBuilder, ColumnModification)

Appends a WHERE condition for the identity (i.e. key value) of the given column.

AppendInsertCommand(StringBuilder, String, String, IReadOnlyList<ColumnModification>)

Appends a SQL command for inserting a row to the commands being built.

AppendInsertCommandHeader(StringBuilder, String, String, IReadOnlyList<ColumnModification>)

Appends a SQL fragment for starting an INSERT.

AppendInsertOperation(StringBuilder, ModificationCommand, Int32)

Appends a SQL command for inserting a row to the commands being built.

AppendNextSequenceValueOperation(StringBuilder, String, String)

Generates a SQL fragment that will get the next value from the given sequence and appends it to the full command being built by the given StringBuilder.

AppendRowsAffectedWhereCondition(StringBuilder, Int32)

Appends a WHERE condition checking rows affected.

AppendSelectAffectedCommand(StringBuilder, String, String, IReadOnlyList<ColumnModification>, IReadOnlyList<ColumnModification>, Int32)

Appends a SQL command for selecting affected data.

AppendSelectAffectedCountCommand(StringBuilder, String, String, Int32)

Appends a SQL command for selecting the number of rows affected.

AppendSelectCommandHeader(StringBuilder, IReadOnlyList<ColumnModification>)

Appends a SQL fragment for starting an SELECT.

AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<ColumnModification>, IReadOnlyList<ColumnModification>)

Appends a SQL command for updating a row to the commands being built.

AppendUpdateCommandHeader(StringBuilder, String, String, IReadOnlyList<ColumnModification>)

Appends a SQL fragment for starting an UPDATE.

AppendUpdateOperation(StringBuilder, ModificationCommand, Int32)

Appends a SQL command for updating a row to the commands being built.

AppendValues(StringBuilder, IReadOnlyList<ColumnModification>)

Appends values after a AppendValuesHeader(StringBuilder, IReadOnlyList<ColumnModification>) call.

AppendValuesHeader(StringBuilder, IReadOnlyList<ColumnModification>)

Appends a SQL fragment for a VALUES.

AppendWhereAffectedClause(StringBuilder, IReadOnlyList<ColumnModification>)

Appends a WHERE clause involving rows affected.

AppendWhereClause(StringBuilder, IReadOnlyList<ColumnModification>)

Appends a WHERE clause.

AppendWhereCondition(StringBuilder, ColumnModification, Boolean)

Appends a WHERE condition for the given column.

GenerateNextSequenceValueOperation(String, String)

Generates SQL that will obtain the next value in the given sequence.

Applies to