SelectExpression.Update Method

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore.Query.SqlExpressions

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

Package:: Microsoft.EntityFrameworkCore.Relational v6.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v7.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v8.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v9.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v5.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.1.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression)	Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.
Update(IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<ProjectionExpression>, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression)	Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.
Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression)	Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.
Update(IReadOnlyList<ProjectionExpression>, IReadOnlyList<TableExpressionBase>, SqlExpression, IReadOnlyList<SqlExpression>, SqlExpression, IReadOnlyList<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)	Obsolete. Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.
Update(List<ProjectionExpression>, List<TableExpressionBase>, SqlExpression, List<SqlExpression>, SqlExpression, List<OrderingExpression>, SqlExpression, SqlExpression, Boolean, String)	Obsolete. Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

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

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

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

Parameters

projections: IReadOnlyList<ProjectionExpression>

The Projection property of the result.

tables: IReadOnlyList<TableExpressionBase>

The Tables property of the result.

predicate: SqlExpression

The Predicate property of the result.

groupBy: IReadOnlyList<SqlExpression>

The GroupBy property of the result.

having: SqlExpression

The Having property of the result.

orderings: IReadOnlyList<OrderingExpression>

The Orderings property of the result.

limit: SqlExpression

The Limit property of the result.

offset: SqlExpression

The Offset property of the result.

Returns

SelectExpression

This expression if no children changed, or an expression with the updated children.

Applies to

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

Source:: SelectExpression.cs

Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression Update (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.ProjectionExpression> projections, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.OrderingExpression> orderings, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? offset, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? limit);

member this.Update : 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.ProjectionExpression> * 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 (tables As IReadOnlyList(Of TableExpressionBase), predicate As SqlExpression, groupBy As IReadOnlyList(Of SqlExpression), having As SqlExpression, projections As IReadOnlyList(Of ProjectionExpression), orderings As IReadOnlyList(Of OrderingExpression), offset As SqlExpression, limit As SqlExpression) As SelectExpression

Parameters

tables: IReadOnlyList<TableExpressionBase>

The Tables property of the result.

predicate: SqlExpression

The Predicate property of the result.

groupBy: IReadOnlyList<SqlExpression>

The GroupBy property of the result.

having: SqlExpression

The Having property of the result.

projections: IReadOnlyList<ProjectionExpression>

The Projection property of the result.

orderings: IReadOnlyList<OrderingExpression>

The Orderings property of the result.

offset: SqlExpression

The Offset property of the result.

limit: SqlExpression

The Limit property of the result.

Returns

SelectExpression

This expression if no children changed, or an expression with the updated children.

Applies to

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

Source:: SelectExpression.cs

Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

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

Parameters

projections: List<ProjectionExpression>

The Projection property of the result.

tables: List<TableExpressionBase>

The Tables property of the result.

predicate: SqlExpression

The Predicate property of the result.

groupBy: List<SqlExpression>

The GroupBy property of the result.

having: SqlExpression

The Having property of the result.

orderings: List<OrderingExpression>

The Orderings property of the result.

limit: SqlExpression

The Limit property of the result.

offset: SqlExpression

The Offset property of the result.

Returns

SelectExpression

This expression if no children changed, or an expression with the updated children.

Applies to

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

Source:: SelectExpression.cs

Caution

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

Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

[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

Parameters

projections: IReadOnlyList<ProjectionExpression>

The Projection property of the result.

tables: IReadOnlyList<TableExpressionBase>

The Tables property of the result.

predicate: SqlExpression

The Predicate property of the result.

groupBy: IReadOnlyList<SqlExpression>

The GroupBy property of the result.

having: SqlExpression

The Having property of the result.

orderings: IReadOnlyList<OrderingExpression>

The Orderings property of the result.

limit: SqlExpression

The Limit property of the result.

offset: SqlExpression

The Offset property of the result.

distinct: Boolean

The IsDistinct property of the result.

alias: String

The Alias property of the result.

Returns

SelectExpression

This expression if no children changed, or an expression with the updated children.

Attributes: ObsoleteAttribute

Applies to

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

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Caution

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

Creates a new expression that is like this one, but using the supplied children. If all of the children are the same, it will return this expression.

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