Condividi tramite


UpdateSqlGenerator.AppendUpdateCommand Metodo

Definizione

Overload

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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

Parametri

commandStringBuilder
StringBuilder

Generatore a cui deve essere accodato sql.

name
String

Nome della tabella.

schema
String

Schema della tabella o null per usare lo schema predefinito.

writeOperations
IReadOnlyList<ColumnModification>

Operazioni per ogni colonna.

conditionOperations
IReadOnlyList<ColumnModification>

Operazioni utilizzate per generare la WHERE clausola per l'aggiornamento.

Si applica a

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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

Parametri

commandStringBuilder
StringBuilder

Generatore a cui deve essere accodato sql.

name
String

Nome della tabella.

schema
String

Schema della tabella o null per usare lo schema predefinito.

writeOperations
IReadOnlyList<IColumnModification>

Operazioni per ogni colonna.

conditionOperations
IReadOnlyList<IColumnModification>

Operazioni utilizzate per generare la WHERE clausola per l'aggiornamento.

Si applica a

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

Aggiunge un comando SQL per aggiornare una riga ai comandi compilati.

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)

Parametri

commandStringBuilder
StringBuilder

Generatore a cui deve essere accodato sql.

name
String

Nome della tabella.

schema
String

Schema della tabella o null per usare lo schema predefinito.

writeOperations
IReadOnlyList<IColumnModification>

Operazioni per ogni colonna.

readOperations
IReadOnlyList<IColumnModification>

Operazioni per la lettura dei valori di colonna.

conditionOperations
IReadOnlyList<IColumnModification>

Operazioni utilizzate per generare la WHERE clausola per l'aggiornamento.

appendReturningOneClause
Boolean

Indica se aggiungere una costante aggiuntiva pari a 1 da leggere.

Si applica a