共用方式為

UpdateSqlGenerator.AppendUpdateCommand 方法

  • 參考

定義

命名空間:
Microsoft.EntityFrameworkCore.Update
組件:
Microsoft.EntityFrameworkCore.Relational.dll
套件:
Microsoft.EntityFrameworkCore.Relational v1.0.6
套件:
Microsoft.EntityFrameworkCore.Relational v1.1.6
套件:
Microsoft.EntityFrameworkCore.Relational v2.0.3
套件:
Microsoft.EntityFrameworkCore.Relational v2.1.11
套件:
Microsoft.EntityFrameworkCore.Relational v2.2.6
套件:
Microsoft.EntityFrameworkCore.Relational v3.0.0
套件:
Microsoft.EntityFrameworkCore.Relational v3.1.0
套件:
Microsoft.EntityFrameworkCore.Relational v5.0.0
套件:
Microsoft.EntityFrameworkCore.Relational v6.0.0
套件:
Microsoft.EntityFrameworkCore.Relational v7.0.0
套件:
Microsoft.EntityFrameworkCore.Relational v8.0.0

多載

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

附加 SQL 命令，以將資料列更新至所建置的命令。
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>)

附加 SQL 命令，以將資料列更新至所建置的命令。
AppendUpdateCommand(StringBuilder, String, String, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, IReadOnlyList<IColumnModification>, Boolean)

附加 SQL 命令，以將資料列更新至所建置的命令。

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

附加 SQL 命令，以將資料列更新至所建置的命令。

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

參數

commandStringBuilder
StringBuilder

應該附加 SQL 的產生器。

name
String

資料表的名稱。

schema
String

資料表架構，或使用 null 預設架構。

writeOperations
IReadOnlyList<ColumnModification>

每個資料行的作業。

conditionOperations
IReadOnlyList<ColumnModification>

用來產生 WHERE 更新子句的作業。

適用於

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

附加 SQL 命令，以將資料列更新至所建置的命令。

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

參數

commandStringBuilder
StringBuilder

應該附加 SQL 的產生器。

name
String

資料表的名稱。

schema
String

資料表架構，或使用 null 預設架構。

writeOperations
IReadOnlyList<IColumnModification>

每個資料行的作業。

conditionOperations
IReadOnlyList<IColumnModification>

用來產生 WHERE 更新子句的作業。

適用於

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

附加 SQL 命令，以將資料列更新至所建置的命令。

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)

參數

commandStringBuilder
StringBuilder

應該附加 SQL 的產生器。

name
String

資料表的名稱。

schema
String

資料表架構，或使用 null 預設架構。

writeOperations
IReadOnlyList<IColumnModification>

每個資料行的作業。

readOperations
IReadOnlyList<IColumnModification>

要讀取的資料行值作業。

conditionOperations
IReadOnlyList<IColumnModification>

用來產生 WHERE 更新子句的作業。

appendReturningOneClause
Boolean

是否要附加額外的常數 1，以便回讀。

適用於