Share via


SelectExpression.Update Method

Definition

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

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

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)

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

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)

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

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

Attributes

Applies to

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

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

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.

havingExpressionhaving
SqlExpression
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.

distinct
Boolean

The IsDistinct property of the result.

alias
String

The Alias property of the result.

Returns

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

Attributes

Applies to