UpdateSqlGenerator.AppendUpdateCommand Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore.Update
Assembly:
Microsoft.EntityFrameworkCore.Relational.dll
Package:
Microsoft.EntityFrameworkCore.Relational v1.0.6
Package:
Microsoft.EntityFrameworkCore.Relational v1.1.6
Package:
Microsoft.EntityFrameworkCore.Relational v2.0.3
Package:
Microsoft.EntityFrameworkCore.Relational v2.1.11
Package:
Microsoft.EntityFrameworkCore.Relational v2.2.6
Package:
Microsoft.EntityFrameworkCore.Relational v3.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v3.1.0
Package:
Microsoft.EntityFrameworkCore.Relational v5.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v6.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v7.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v8.0.0

Overloads

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

Appends a SQL command for updating a row to the commands being built.
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>)

Appends a SQL command for updating a row to the commands being built.
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, Boolean)

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

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

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

protected virtual void AppendUpdateCommand (System.Text.StringBuilder commandStringBuilder, string name, string schema, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> writeOperations, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> conditionOperations);
abstract member AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> -> unit
override this.AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.ColumnModification> -> unit
Protected Overridable Sub AppendUpdateCommand (commandStringBuilder As StringBuilder, name As String, schema As String, writeOperations As IReadOnlyList(Of ColumnModification), conditionOperations As IReadOnlyList(Of ColumnModification))

Parameters

commandStringBuilder
StringBuilder

The builder to which the SQL should be appended.

name
String

The name of the table.

schema
String

The table schema, or null to use the default schema.

writeOperations
IReadOnlyList<ColumnModification>

The operations for each column.

conditionOperations
IReadOnlyList<ColumnModification>

The operations used to generate the WHERE clause for the update.

Applies to

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

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

protected virtual void AppendUpdateCommand (System.Text.StringBuilder commandStringBuilder, string name, string? schema, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> writeOperations, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> conditionOperations);
abstract member AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> -> unit
override this.AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> -> unit
Protected Overridable Sub AppendUpdateCommand (commandStringBuilder As StringBuilder, name As String, schema As String, writeOperations As IReadOnlyList(Of IColumnModification), conditionOperations As IReadOnlyList(Of IColumnModification))

Parameters

commandStringBuilder
StringBuilder

The builder to which the SQL should be appended.

name
String

The name of the table.

schema
String

The table schema, or null to use the default schema.

writeOperations
IReadOnlyList<IColumnModification>

The operations for each column.

conditionOperations
IReadOnlyList<IColumnModification>

The operations used to generate the WHERE clause for the update.

Applies to

AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, Boolean)

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

protected virtual void AppendUpdateCommand (System.Text.StringBuilder commandStringBuilder, string name, string? schema, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> writeOperations, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> readOperations, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> conditionOperations, bool appendReturningOneClause = false);
abstract member AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * bool -> unit
override this.AppendUpdateCommand : System.Text.StringBuilder * string * string * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Update.IColumnModification> * bool -> unit
Protected Overridable Sub AppendUpdateCommand (commandStringBuilder As StringBuilder, name As String, schema As String, writeOperations As IReadOnlyList(Of IColumnModification), readOperations As IReadOnlyList(Of IColumnModification), conditionOperations As IReadOnlyList(Of IColumnModification), Optional appendReturningOneClause As Boolean = false)

Parameters

commandStringBuilder
StringBuilder

The builder to which the SQL should be appended.

name
String

The name of the table.

schema
String

The table schema, or null to use the default schema.

writeOperations
IReadOnlyList<IColumnModification>

The operations for each column.

readOperations
IReadOnlyList<IColumnModification>

The operations for column values to be read back.

conditionOperations
IReadOnlyList<IColumnModification>

The operations used to generate the WHERE clause for the update.

appendReturningOneClause
Boolean

Whether to append an additional constant of 1 to be read back.

Applies to