語言

UpdateSqlGenerator.AppendUpdateCommand 方法

定義

多載

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

來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs

在正在建立的指令中附加一個 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>)

來源:
UpdateSqlGenerator.cs

在正在建立的指令中附加一個 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)

來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs
來源:
UpdateSqlGenerator.cs

在正在建立的指令中附加一個 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 以便讀取。

適用於