Compartilhar via

UpdateSqlGenerator.AppendUpdateCommand Método

  • Referência

Definição

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

Sobrecargas

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

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>)

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, Boolean)

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.

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

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.

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))

Parâmetros

commandStringBuilder
StringBuilder

O construtor ao qual o SQL deve ser acrescentado.

name
String

O nome da tabela.

schema
String

O esquema da tabela ou null para usar o esquema padrão.

writeOperations
IReadOnlyList<ColumnModification>

As operações para cada coluna.

conditionOperations
IReadOnlyList<ColumnModification>

As operações usadas para gerar a WHERE cláusula para a atualização.

Aplica-se a

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

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.

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))

Parâmetros

commandStringBuilder
StringBuilder

O construtor ao qual o SQL deve ser acrescentado.

name
String

O nome da tabela.

schema
String

O esquema da tabela ou null para usar o esquema padrão.

writeOperations
IReadOnlyList<IColumnModification>

As operações para cada coluna.

conditionOperations
IReadOnlyList<IColumnModification>

As operações usadas para gerar a WHERE cláusula para a atualização.

Aplica-se a

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

Acrescenta um comando SQL para atualizar uma linha para os comandos que estão sendo criados.

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)

Parâmetros

commandStringBuilder
StringBuilder

O construtor ao qual o SQL deve ser acrescentado.

name
String

O nome da tabela.

schema
String

O esquema da tabela ou null para usar o esquema padrão.

writeOperations
IReadOnlyList<IColumnModification>

As operações para cada coluna.

readOperations
IReadOnlyList<IColumnModification>

As operações para valores de coluna a serem lidos novamente.

conditionOperations
IReadOnlyList<IColumnModification>

As operações usadas para gerar a WHERE cláusula para a atualização.

appendReturningOneClause
Boolean

Se deve acrescentar uma constante adicional de 1 a ser lida novamente.

Aplica-se a