SelectExpression.Update 方法

參考

定義

命名空間:: Microsoft.EntityFrameworkCore.Query.SqlExpressions

組件:: Microsoft.EntityFrameworkCore.Relational.dll

套件:: Microsoft.EntityFrameworkCore.Relational v6.0.0

套件:: Microsoft.EntityFrameworkCore.Relational v7.0.0

套件:: Microsoft.EntityFrameworkCore.Relational v8.0.0

套件:: Microsoft.EntityFrameworkCore.Relational v5.0.0

套件:: Microsoft.EntityFrameworkCore.Relational v3.0.0

套件:: Microsoft.EntityFrameworkCore.Relational v3.1.0

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

多載

Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression)	建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。
Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression)	建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。
Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)	已淘汰. 建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。
Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)	已淘汰. 建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。

Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression)

建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> projections, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> tables, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? predicate, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> groupBy, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? having, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? limit, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? offset);

member this.Update : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression

Public Function Update (projections As IReadOnlyList(Of ProjectionExpression), tables As IReadOnlyList(Of TableExpressionBase), predicate As SqlExpression, groupBy As IReadOnlyList(Of SqlExpression), having As SqlExpression, orderings As IReadOnlyList(Of OrderingExpression), limit As SqlExpression, offset As SqlExpression) As SelectExpression

參數

projections: IReadOnlyList<ProjectionExpression>

結果的 Projection 屬性。

tables: IReadOnlyList<TableExpressionBase>

結果的 Tables 屬性。

predicate: SqlExpression

結果的 Predicate 屬性。

groupBy: IReadOnlyList<SqlExpression>

結果的 GroupBy 屬性。

having: SqlExpression

結果的 Having 屬性。

orderings: IReadOnlyList<OrderingExpression>

結果的 Orderings 屬性。

limit: SqlExpression

結果的 Limit 屬性。

offset: SqlExpression

結果的 Offset 屬性。

傳回

SelectExpression

如果沒有變更任何子系則為這個運算式，否則為具有更新之子系的運算式。

適用於

Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression)

建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> projections, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> tables, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression predicate, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> groupBy, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression having, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression limit, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression offset);

member this.Update : System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression

Public Function Update (projections As List(Of ProjectionExpression), tables As List(Of TableExpressionBase), predicate As SqlExpression, groupBy As List(Of SqlExpression), having As SqlExpression, orderings As List(Of OrderingExpression), limit As SqlExpression, offset As SqlExpression) As SelectExpression

參數

projections: List<ProjectionExpression>

結果的 Projection 屬性。

tables: List<TableExpressionBase>

結果的 Tables 屬性。

predicate: SqlExpression

結果的 Predicate 屬性。

groupBy: List<SqlExpression>

結果的 GroupBy 屬性。

having: SqlExpression

結果的 Having 屬性。

orderings: List<OrderingExpression>

結果的 Orderings 屬性。

limit: SqlExpression

結果的 Limit 屬性。

offset: SqlExpression

結果的 Offset 屬性。

傳回

SelectExpression

如果沒有變更任何子系則為這個運算式，否則為具有更新之子系的運算式。

適用於

Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)

警告

Use the overload which does not require distinct & alias parameter.

建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。

[System.Obsolete("Use the overload which does not require distinct & alias parameter.")]
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> projections, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> tables, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? predicate, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> groupBy, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? having, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? limit, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? offset, bool distinct, string? alias);

[<System.Obsolete("Use the overload which does not require distinct & alias parameter.")>]
member this.Update : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * bool * string -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression

Public Function Update (projections As IReadOnlyList(Of ProjectionExpression), tables As IReadOnlyList(Of TableExpressionBase), predicate As SqlExpression, groupBy As IReadOnlyList(Of SqlExpression), having As SqlExpression, orderings As IReadOnlyList(Of OrderingExpression), limit As SqlExpression, offset As SqlExpression, distinct As Boolean, alias As String) As SelectExpression

參數

projections: IReadOnlyList<ProjectionExpression>

結果的 Projection 屬性。

tables: IReadOnlyList<TableExpressionBase>

結果的 Tables 屬性。

predicate: SqlExpression

結果的 Predicate 屬性。

groupBy: IReadOnlyList<SqlExpression>

結果的 GroupBy 屬性。

having: SqlExpression

結果的 Having 屬性。

orderings: IReadOnlyList<OrderingExpression>

結果的 Orderings 屬性。

limit: SqlExpression

結果的 Limit 屬性。

offset: SqlExpression

結果的 Offset 屬性。

distinct: Boolean

結果的 IsDistinct 屬性。

alias: String

結果的 Alias 屬性。

傳回

SelectExpression

如果沒有變更任何子系則為這個運算式，否則為具有更新之子系的運算式。

屬性: ObsoleteAttribute

適用於

Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)

警告

Use the overload which does not require distinct & alias parameter.

建立類似這個運算式的新運算式，但使用提供的子系。如果所有子系都相同，則會傳回這個運算式。

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> projections, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> tables, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression predicate, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> groupBy, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression havingExpression, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression limit, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression offset, bool distinct, string alias);

[System.Obsolete("Use the overload which does not require distinct & alias parameter.")]
public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> projections, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> tables, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression predicate, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> groupBy, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression having, System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression limit, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression offset, bool distinct, string alias);

member this.Update : System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * bool * string -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression

[<System.Obsolete("Use the overload which does not require distinct & alias parameter.")>]
member this.Update : System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.ProjectionExpression> * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.TableExpressionBase> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.List<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * bool * string -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression

Public Function Update (projections As List(Of ProjectionExpression), tables As List(Of TableExpressionBase), predicate As SqlExpression, groupBy As List(Of SqlExpression), havingExpression As SqlExpression, orderings As List(Of OrderingExpression), limit As SqlExpression, offset As SqlExpression, distinct As Boolean, alias As String) As SelectExpression

Public Function Update (projections As List(Of ProjectionExpression), tables As List(Of TableExpressionBase), predicate As SqlExpression, groupBy As List(Of SqlExpression), having As SqlExpression, orderings As List(Of OrderingExpression), limit As SqlExpression, offset As SqlExpression, distinct As Boolean, alias As String) As SelectExpression