IUpdateSqlGenerator Interface

Definition

Namespace:

Microsoft.EntityFrameworkCore.Update

Assembly:

Microsoft.EntityFrameworkCore.Relational.dll

Package:

Microsoft.EntityFrameworkCore.Relational v8.0.0

A service used to generate SQL for insert, update, and delete commands, and related SQL operations needed for SaveChanges()

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

public interface IUpdateSqlGenerator

type IUpdateSqlGenerator = interface

Public Interface IUpdateSqlGenerator

Derived

Microsoft.EntityFrameworkCore.Update.UpdateSqlGenerator

Remarks

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.

See Implementation of database providers and extensions for more information and examples.

Methods

AppendBatchHeader(StringBuilder)	Appends a SQL fragment for the start of a batch to the full command being built by the given StringBuilder.
AppendDeleteOperation(StringBuilder, IReadOnlyModificationCommand, Int32, Boolean)	Appends a SQL command for deleting a row to the commands being built.
AppendDeleteOperation(StringBuilder, IReadOnlyModificationCommand, Int32)	Appends a SQL command for deleting a row to the commands being built.
AppendInsertOperation(StringBuilder, IReadOnlyModificationCommand, Int32, Boolean)	Appends a SQL command for inserting a row to the commands being built.
AppendInsertOperation(StringBuilder, IReadOnlyModificationCommand, Int32)	Appends a SQL command for inserting a row to the commands being built.
AppendNextSequenceValueOperation(StringBuilder, String, String)	Generates a SQL fragment that will query for the next value from the given sequence and appends it to the full command being built by the given StringBuilder.
AppendObtainNextSequenceValueOperation(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.
AppendStoredProcedureCall(StringBuilder, IReadOnlyModificationCommand, Int32, Boolean)	Appends SQL for calling a stored procedure.
AppendUpdateOperation(StringBuilder, IReadOnlyModificationCommand, Int32, Boolean)	Appends a SQL command for updating a row to the commands being built.
AppendUpdateOperation(StringBuilder, IReadOnlyModificationCommand, Int32)	Appends a SQL command for updating a row to the commands being built.
GenerateNextSequenceValueOperation(String, String)	Generates SQL that will query for the next value in the given sequence.
GenerateObtainNextSequenceValueOperation(String, String)	Generates SQL that will obtain the next value in the given sequence.
PrependEnsureAutocommit(StringBuilder)	Prepends a SQL command for turning on autocommit mode in the database, in case it is off.