Class SelectExpression

Namespace

Microsoft.EntityFrameworkCore.Query.SqlExpressions

Assembly

Microsoft.EntityFrameworkCore.Relational.dll

An expression that represents a SELECT in a SQL tree.

This type is typically used by database providers (and other extensions). It is generally not used in application code.

This class is not publicly constructable. If this is a problem for your application or provider, then please file an issue at https://github.com/dotnet/efcore.

public sealed class SelectExpression : TableExpressionBase, IPrintableExpression

Inheritance

object

Expression

TableExpressionBase

SelectExpression

Implements

IPrintableExpression

Inherited Members

TableExpressionBase.Alias

TableExpressionBase.Type

TableExpressionBase.NodeType

Expression.Assign(Expression, Expression)

Expression.MakeBinary(ExpressionType, Expression, Expression)

Expression.MakeBinary(ExpressionType, Expression, Expression, bool, MethodInfo)

Expression.MakeBinary(ExpressionType, Expression, Expression, bool, MethodInfo, LambdaExpression)

Expression.Equal(Expression, Expression)

Expression.Equal(Expression, Expression, bool, MethodInfo)

Expression.ReferenceEqual(Expression, Expression)

Expression.NotEqual(Expression, Expression)

Expression.NotEqual(Expression, Expression, bool, MethodInfo)

Expression.ReferenceNotEqual(Expression, Expression)

Expression.GreaterThan(Expression, Expression)

Expression.GreaterThan(Expression, Expression, bool, MethodInfo)

Expression.LessThan(Expression, Expression)

Expression.LessThan(Expression, Expression, bool, MethodInfo)

Expression.GreaterThanOrEqual(Expression, Expression)

Expression.GreaterThanOrEqual(Expression, Expression, bool, MethodInfo)

Expression.LessThanOrEqual(Expression, Expression)

Expression.LessThanOrEqual(Expression, Expression, bool, MethodInfo)

Expression.AndAlso(Expression, Expression)

Expression.AndAlso(Expression, Expression, MethodInfo)

Expression.OrElse(Expression, Expression)

Expression.OrElse(Expression, Expression, MethodInfo)

Expression.Coalesce(Expression, Expression)

Expression.Coalesce(Expression, Expression, LambdaExpression)

Expression.Add(Expression, Expression)

Expression.Add(Expression, Expression, MethodInfo)

Expression.AddAssign(Expression, Expression)

Expression.AddAssign(Expression, Expression, MethodInfo)

Expression.AddAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.AddAssignChecked(Expression, Expression)

Expression.AddAssignChecked(Expression, Expression, MethodInfo)

Expression.AddAssignChecked(Expression, Expression, MethodInfo, LambdaExpression)

Expression.AddChecked(Expression, Expression)

Expression.AddChecked(Expression, Expression, MethodInfo)

Expression.Subtract(Expression, Expression)

Expression.Subtract(Expression, Expression, MethodInfo)

Expression.SubtractAssign(Expression, Expression)

Expression.SubtractAssign(Expression, Expression, MethodInfo)

Expression.SubtractAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.SubtractAssignChecked(Expression, Expression)

Expression.SubtractAssignChecked(Expression, Expression, MethodInfo)

Expression.SubtractAssignChecked(Expression, Expression, MethodInfo, LambdaExpression)

Expression.SubtractChecked(Expression, Expression)

Expression.SubtractChecked(Expression, Expression, MethodInfo)

Expression.Divide(Expression, Expression)

Expression.Divide(Expression, Expression, MethodInfo)

Expression.DivideAssign(Expression, Expression)

Expression.DivideAssign(Expression, Expression, MethodInfo)

Expression.DivideAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.Modulo(Expression, Expression)

Expression.Modulo(Expression, Expression, MethodInfo)

Expression.ModuloAssign(Expression, Expression)

Expression.ModuloAssign(Expression, Expression, MethodInfo)

Expression.ModuloAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.Multiply(Expression, Expression)

Expression.Multiply(Expression, Expression, MethodInfo)

Expression.MultiplyAssign(Expression, Expression)

Expression.MultiplyAssign(Expression, Expression, MethodInfo)

Expression.MultiplyAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.MultiplyAssignChecked(Expression, Expression)

Expression.MultiplyAssignChecked(Expression, Expression, MethodInfo)

Expression.MultiplyAssignChecked(Expression, Expression, MethodInfo, LambdaExpression)

Expression.MultiplyChecked(Expression, Expression)

Expression.MultiplyChecked(Expression, Expression, MethodInfo)

Expression.LeftShift(Expression, Expression)

Expression.LeftShift(Expression, Expression, MethodInfo)

Expression.LeftShiftAssign(Expression, Expression)

Expression.LeftShiftAssign(Expression, Expression, MethodInfo)

Expression.LeftShiftAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.RightShift(Expression, Expression)

Expression.RightShift(Expression, Expression, MethodInfo)

Expression.RightShiftAssign(Expression, Expression)

Expression.RightShiftAssign(Expression, Expression, MethodInfo)

Expression.RightShiftAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.And(Expression, Expression)

Expression.And(Expression, Expression, MethodInfo)

Expression.AndAssign(Expression, Expression)

Expression.AndAssign(Expression, Expression, MethodInfo)

Expression.AndAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.Or(Expression, Expression)

Expression.Or(Expression, Expression, MethodInfo)

Expression.OrAssign(Expression, Expression)

Expression.OrAssign(Expression, Expression, MethodInfo)

Expression.OrAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.ExclusiveOr(Expression, Expression)

Expression.ExclusiveOr(Expression, Expression, MethodInfo)

Expression.ExclusiveOrAssign(Expression, Expression)

Expression.ExclusiveOrAssign(Expression, Expression, MethodInfo)

Expression.ExclusiveOrAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.Power(Expression, Expression)

Expression.Power(Expression, Expression, MethodInfo)

Expression.PowerAssign(Expression, Expression)

Expression.PowerAssign(Expression, Expression, MethodInfo)

Expression.PowerAssign(Expression, Expression, MethodInfo, LambdaExpression)

Expression.ArrayIndex(Expression, Expression)

Expression.Block(Expression, Expression)

Expression.Block(Expression, Expression, Expression)

Expression.Block(Expression, Expression, Expression, Expression)

Expression.Block(Expression, Expression, Expression, Expression, Expression)

Expression.Block(params Expression[])

Expression.Block(IEnumerable<Expression>)

Expression.Block(Type, params Expression[])

Expression.Block(Type, IEnumerable<Expression>)

Expression.Block(IEnumerable<ParameterExpression>, params Expression[])

Expression.Block(Type, IEnumerable<ParameterExpression>, params Expression[])

Expression.Block(IEnumerable<ParameterExpression>, IEnumerable<Expression>)

Expression.Block(Type, IEnumerable<ParameterExpression>, IEnumerable<Expression>)

Expression.Catch(Type, Expression)

Expression.Catch(ParameterExpression, Expression)

Expression.Catch(Type, Expression, Expression)

Expression.Catch(ParameterExpression, Expression, Expression)

Expression.MakeCatchBlock(Type, ParameterExpression, Expression, Expression)

Expression.Condition(Expression, Expression, Expression)

Expression.Condition(Expression, Expression, Expression, Type)

Expression.IfThen(Expression, Expression)

Expression.IfThenElse(Expression, Expression, Expression)

Expression.Constant(object)

Expression.Constant(object, Type)

Expression.DebugInfo(SymbolDocumentInfo, int, int, int, int)

Expression.ClearDebugInfo(SymbolDocumentInfo)

Expression.Empty()

Expression.Default(Type)

Expression.ElementInit(MethodInfo, params Expression[])

Expression.ElementInit(MethodInfo, IEnumerable<Expression>)

Expression.Reduce()

Expression.ReduceAndCheck()

Expression.ReduceExtensions()

Expression.ToString()

Expression.Dynamic(CallSiteBinder, Type, IEnumerable<Expression>)

Expression.Dynamic(CallSiteBinder, Type, Expression)

Expression.Dynamic(CallSiteBinder, Type, Expression, Expression)

Expression.Dynamic(CallSiteBinder, Type, Expression, Expression, Expression)

Expression.Dynamic(CallSiteBinder, Type, Expression, Expression, Expression, Expression)

Expression.Dynamic(CallSiteBinder, Type, params Expression[])

Expression.MakeDynamic(Type, CallSiteBinder, IEnumerable<Expression>)

Expression.MakeDynamic(Type, CallSiteBinder, Expression)

Expression.MakeDynamic(Type, CallSiteBinder, Expression, Expression)

Expression.MakeDynamic(Type, CallSiteBinder, Expression, Expression, Expression)

Expression.MakeDynamic(Type, CallSiteBinder, Expression, Expression, Expression, Expression)

Expression.MakeDynamic(Type, CallSiteBinder, params Expression[])

Expression.Break(LabelTarget)

Expression.Break(LabelTarget, Expression)

Expression.Break(LabelTarget, Type)

Expression.Break(LabelTarget, Expression, Type)

Expression.Continue(LabelTarget)

Expression.Continue(LabelTarget, Type)

Expression.Return(LabelTarget)

Expression.Return(LabelTarget, Type)

Expression.Return(LabelTarget, Expression)

Expression.Return(LabelTarget, Expression, Type)

Expression.Goto(LabelTarget)

Expression.Goto(LabelTarget, Type)

Expression.Goto(LabelTarget, Expression)

Expression.Goto(LabelTarget, Expression, Type)

Expression.MakeGoto(GotoExpressionKind, LabelTarget, Expression, Type)

Expression.MakeIndex(Expression, PropertyInfo, IEnumerable<Expression>)

Expression.ArrayAccess(Expression, params Expression[])

Expression.ArrayAccess(Expression, IEnumerable<Expression>)

Expression.Property(Expression, string, params Expression[])

Expression.Property(Expression, PropertyInfo, params Expression[])

Expression.Property(Expression, PropertyInfo, IEnumerable<Expression>)

Expression.Invoke(Expression, params Expression[])

Expression.Invoke(Expression, IEnumerable<Expression>)

Expression.Label(LabelTarget)

Expression.Label(LabelTarget, Expression)

Expression.Label()

Expression.Label(string)

Expression.Label(Type)

Expression.Label(Type, string)

Expression.Lambda<TDelegate>(Expression, params ParameterExpression[])

Expression.Lambda<TDelegate>(Expression, bool, params ParameterExpression[])

Expression.Lambda<TDelegate>(Expression, IEnumerable<ParameterExpression>)

Expression.Lambda<TDelegate>(Expression, bool, IEnumerable<ParameterExpression>)

Expression.Lambda<TDelegate>(Expression, string, IEnumerable<ParameterExpression>)

Expression.Lambda<TDelegate>(Expression, string, bool, IEnumerable<ParameterExpression>)

Expression.Lambda(Expression, params ParameterExpression[])

Expression.Lambda(Expression, bool, params ParameterExpression[])

Expression.Lambda(Expression, IEnumerable<ParameterExpression>)

Expression.Lambda(Expression, bool, IEnumerable<ParameterExpression>)

Expression.Lambda(Type, Expression, params ParameterExpression[])

Expression.Lambda(Type, Expression, bool, params ParameterExpression[])

Expression.Lambda(Type, Expression, IEnumerable<ParameterExpression>)

Expression.Lambda(Type, Expression, bool, IEnumerable<ParameterExpression>)

Expression.Lambda(Expression, string, IEnumerable<ParameterExpression>)

Expression.Lambda(Expression, string, bool, IEnumerable<ParameterExpression>)

Expression.Lambda(Type, Expression, string, IEnumerable<ParameterExpression>)

Expression.Lambda(Type, Expression, string, bool, IEnumerable<ParameterExpression>)

Expression.GetFuncType(params Type[])

Expression.TryGetFuncType(Type[], out Type)

Expression.GetActionType(params Type[])

Expression.TryGetActionType(Type[], out Type)

Expression.GetDelegateType(params Type[])

Expression.ListInit(NewExpression, params Expression[])

Expression.ListInit(NewExpression, IEnumerable<Expression>)

Expression.ListInit(NewExpression, MethodInfo, params Expression[])

Expression.ListInit(NewExpression, MethodInfo, IEnumerable<Expression>)

Expression.ListInit(NewExpression, params ElementInit[])

Expression.ListInit(NewExpression, IEnumerable<ElementInit>)

Expression.Loop(Expression)

Expression.Loop(Expression, LabelTarget)

Expression.Loop(Expression, LabelTarget, LabelTarget)

Expression.Bind(MemberInfo, Expression)

Expression.Bind(MethodInfo, Expression)

Expression.Field(Expression, FieldInfo)

Expression.Field(Expression, string)

Expression.Field(Expression, Type, string)

Expression.Property(Expression, string)

Expression.Property(Expression, Type, string)

Expression.Property(Expression, PropertyInfo)

Expression.Property(Expression, MethodInfo)

Expression.PropertyOrField(Expression, string)

Expression.MakeMemberAccess(Expression, MemberInfo)

Expression.MemberInit(NewExpression, params MemberBinding[])

Expression.MemberInit(NewExpression, IEnumerable<MemberBinding>)

Expression.ListBind(MemberInfo, params ElementInit[])

Expression.ListBind(MemberInfo, IEnumerable<ElementInit>)

Expression.ListBind(MethodInfo, params ElementInit[])

Expression.ListBind(MethodInfo, IEnumerable<ElementInit>)

Expression.MemberBind(MemberInfo, params MemberBinding[])

Expression.MemberBind(MemberInfo, IEnumerable<MemberBinding>)

Expression.MemberBind(MethodInfo, params MemberBinding[])

Expression.MemberBind(MethodInfo, IEnumerable<MemberBinding>)

Expression.Call(MethodInfo, Expression)

Expression.Call(MethodInfo, Expression, Expression)

Expression.Call(MethodInfo, Expression, Expression, Expression)

Expression.Call(MethodInfo, Expression, Expression, Expression, Expression)

Expression.Call(MethodInfo, Expression, Expression, Expression, Expression, Expression)

Expression.Call(MethodInfo, params Expression[])

Expression.Call(MethodInfo, IEnumerable<Expression>)

Expression.Call(Expression, MethodInfo)

Expression.Call(Expression, MethodInfo, params Expression[])

Expression.Call(Expression, MethodInfo, Expression, Expression)

Expression.Call(Expression, MethodInfo, Expression, Expression, Expression)

Expression.Call(Expression, string, Type[], params Expression[])

Expression.Call(Type, string, Type[], params Expression[])

Expression.Call(Expression, MethodInfo, IEnumerable<Expression>)

Expression.ArrayIndex(Expression, params Expression[])

Expression.ArrayIndex(Expression, IEnumerable<Expression>)

Expression.NewArrayInit(Type, params Expression[])

Expression.NewArrayInit(Type, IEnumerable<Expression>)

Expression.NewArrayBounds(Type, params Expression[])

Expression.NewArrayBounds(Type, IEnumerable<Expression>)

Expression.New(ConstructorInfo)

Expression.New(ConstructorInfo, params Expression[])

Expression.New(ConstructorInfo, IEnumerable<Expression>)

Expression.New(ConstructorInfo, IEnumerable<Expression>, IEnumerable<MemberInfo>)

Expression.New(ConstructorInfo, IEnumerable<Expression>, params MemberInfo[])

Expression.New(Type)

Expression.Parameter(Type)

Expression.Variable(Type)

Expression.Parameter(Type, string)

Expression.Variable(Type, string)

Expression.RuntimeVariables(params ParameterExpression[])

Expression.RuntimeVariables(IEnumerable<ParameterExpression>)

Expression.SwitchCase(Expression, params Expression[])

Expression.SwitchCase(Expression, IEnumerable<Expression>)

Expression.Switch(Expression, params SwitchCase[])

Expression.Switch(Expression, Expression, params SwitchCase[])

Expression.Switch(Expression, Expression, MethodInfo, params SwitchCase[])

Expression.Switch(Type, Expression, Expression, MethodInfo, params SwitchCase[])

Expression.Switch(Expression, Expression, MethodInfo, IEnumerable<SwitchCase>)

Expression.Switch(Type, Expression, Expression, MethodInfo, IEnumerable<SwitchCase>)

Expression.SymbolDocument(string)

Expression.SymbolDocument(string, Guid)

Expression.SymbolDocument(string, Guid, Guid)

Expression.SymbolDocument(string, Guid, Guid, Guid)

Expression.TryFault(Expression, Expression)

Expression.TryFinally(Expression, Expression)

Expression.TryCatch(Expression, params CatchBlock[])

Expression.TryCatchFinally(Expression, Expression, params CatchBlock[])

Expression.MakeTry(Type, Expression, Expression, Expression, IEnumerable<CatchBlock>)

Expression.TypeIs(Expression, Type)

Expression.TypeEqual(Expression, Type)

Expression.MakeUnary(ExpressionType, Expression, Type)

Expression.MakeUnary(ExpressionType, Expression, Type, MethodInfo)

Expression.Negate(Expression)

Expression.Negate(Expression, MethodInfo)

Expression.UnaryPlus(Expression)

Expression.UnaryPlus(Expression, MethodInfo)

Expression.NegateChecked(Expression)

Expression.NegateChecked(Expression, MethodInfo)

Expression.Not(Expression)

Expression.Not(Expression, MethodInfo)

Expression.IsFalse(Expression)

Expression.IsFalse(Expression, MethodInfo)

Expression.IsTrue(Expression)

Expression.IsTrue(Expression, MethodInfo)

Expression.OnesComplement(Expression)

Expression.OnesComplement(Expression, MethodInfo)

Expression.TypeAs(Expression, Type)

Expression.Unbox(Expression, Type)

Expression.Convert(Expression, Type)

Expression.Convert(Expression, Type, MethodInfo)

Expression.ConvertChecked(Expression, Type)

Expression.ConvertChecked(Expression, Type, MethodInfo)

Expression.ArrayLength(Expression)

Expression.Quote(Expression)

Expression.Rethrow()

Expression.Rethrow(Type)

Expression.Throw(Expression)

Expression.Throw(Expression, Type)

Expression.Increment(Expression)

Expression.Increment(Expression, MethodInfo)

Expression.Decrement(Expression)

Expression.Decrement(Expression, MethodInfo)

Expression.PreIncrementAssign(Expression)

Expression.PreIncrementAssign(Expression, MethodInfo)

Expression.PreDecrementAssign(Expression)

Expression.PreDecrementAssign(Expression, MethodInfo)

Expression.PostIncrementAssign(Expression)

Expression.PostIncrementAssign(Expression, MethodInfo)

Expression.PostDecrementAssign(Expression)

Expression.PostDecrementAssign(Expression, MethodInfo)

Expression.CanReduce

object.GetType()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Properties

GroupBy

The SQL GROUP BY clause for the SELECT.

public IReadOnlyList<SqlExpression> GroupBy { get; }

Property Value

IReadOnlyList<SqlExpression>

Having

The HAVING predicate for the SELECT when GroupBy clause exists.

public SqlExpression Having { get; }

Property Value

SqlExpression

IsDistinct

A bool value indicating if DISTINCT is applied to projection of this SelectExpression.

public bool IsDistinct { get; }

Property Value

bool

Limit

The limit applied to the number of rows in the result set.

public SqlExpression Limit { get; }

Property Value

SqlExpression

Offset

The offset to skip rows from the result set.

public SqlExpression Offset { get; }

Property Value

SqlExpression

Orderings

The list of orderings used to sort the result set.

public IReadOnlyList<OrderingExpression> Orderings { get; }

Property Value

IReadOnlyList<OrderingExpression>

Predicate

The WHERE predicate for the SELECT.

public SqlExpression Predicate { get; }

Property Value

SqlExpression

Projection

The list of expressions being projected out from the result set.

public IReadOnlyList<ProjectionExpression> Projection { get; }

Property Value

IReadOnlyList<ProjectionExpression>

Tables

The list of tables sources used to generate the result set.

public IReadOnlyList<TableExpressionBase> Tables { get; }

Property Value

IReadOnlyList<TableExpressionBase>

Tags

The list of tags applied to this SelectExpression.

public ISet<string> Tags { get; }

Property Value

ISet<string>

Methods

AddCollectionProjection(ShapedQueryExpression, INavigationBase, Type)

Adds a collection to the projection of the SelectExpression.

public CollectionShaperExpression AddCollectionProjection(ShapedQueryExpression shapedQueryExpression, INavigationBase navigation, Type elementType)

Parameters

shapedQueryExpression ShapedQueryExpression

A shaped query expression for the subquery producing collection result.

navigation INavigationBase

A navigation associated with this collection, if any.

elementType Type

The type of the element in the collection.

Returns

CollectionShaperExpression

A Microsoft.EntityFrameworkCore.Query.CollectionShaperExpression which represents shaping of this collection.

AddCrossApply(ShapedQueryExpression, Expression)

Adds the query expression of the given Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to table sources using CROSS APPLY and combine shapers.

public Expression AddCrossApply(ShapedQueryExpression innerSource, Expression outerShaper)

Parameters

innerSource ShapedQueryExpression

A Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to join with.

outerShaper Expression

An expression for outer shaper.

Returns

Expression

An expression which shapes the result of this join.

AddCrossApply(SelectExpression)

Adds the given SelectExpression to table sources using CROSS APPLY.

public void AddCrossApply(SelectExpression innerSelectExpression)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

AddCrossApply(SelectExpression, Type)

Adds the given SelectExpression to table sources using CROSS APPLY.

[Obsolete("Use the other overloads.")]
public void AddCrossApply(SelectExpression innerSelectExpression, Type transparentIdentifierType)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

transparentIdentifierType Type

The type of the result generated after performing the join.

AddCrossJoin(ShapedQueryExpression, Expression)

Adds the query expression of the given Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to table sources using CROSS JOIN and combine shapers.

public Expression AddCrossJoin(ShapedQueryExpression innerSource, Expression outerShaper)

Parameters

innerSource ShapedQueryExpression

A Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to join with.

outerShaper Expression

An expression for outer shaper.

Returns

Expression

An expression which shapes the result of this join.

AddCrossJoin(SelectExpression)

Adds the given SelectExpression to table sources using CROSS JOIN.

public void AddCrossJoin(SelectExpression innerSelectExpression)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

AddCrossJoin(SelectExpression, Type)

Adds the given SelectExpression to table sources using CROSS JOIN.

[Obsolete("Use the other overloads.")]
public void AddCrossJoin(SelectExpression innerSelectExpression, Type transparentIdentifierType)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

transparentIdentifierType Type

The type of the result generated after performing the join.

AddInnerJoin(ShapedQueryExpression, SqlExpression, Expression)

Adds the query expression of the given Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to table sources using INNER JOIN and combine shapers.

public Expression AddInnerJoin(ShapedQueryExpression innerSource, SqlExpression joinPredicate, Expression outerShaper)

Parameters

innerSource ShapedQueryExpression

A Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

outerShaper Expression

An expression for outer shaper.

Returns

Expression

An expression which shapes the result of this join.

AddInnerJoin(SelectExpression, SqlExpression)

Adds the given SelectExpression to table sources using INNER JOIN.

public void AddInnerJoin(SelectExpression innerSelectExpression, SqlExpression joinPredicate)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

AddInnerJoin(SelectExpression, SqlExpression, Type)

Adds the given SelectExpression to table sources using INNER JOIN.

[Obsolete("Use the other overloads.")]
public void AddInnerJoin(SelectExpression innerSelectExpression, SqlExpression joinPredicate, Type transparentIdentifierType)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

transparentIdentifierType Type

The type of the result generated after performing the join.

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

Adds the query expression of the given Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to table sources using LEFT JOIN and combine shapers.

public Expression AddLeftJoin(ShapedQueryExpression innerSource, SqlExpression joinPredicate, Expression outerShaper)

Parameters

innerSource ShapedQueryExpression

A Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

outerShaper Expression

An expression for outer shaper.

Returns

Expression

An expression which shapes the result of this join.

AddLeftJoin(SelectExpression, SqlExpression)

Adds the given SelectExpression to table sources using LEFT JOIN.

public void AddLeftJoin(SelectExpression innerSelectExpression, SqlExpression joinPredicate)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

AddLeftJoin(SelectExpression, SqlExpression, Type)

Adds the given SelectExpression to table sources using LEFT JOIN.

[Obsolete("Use the other overloads.")]
public void AddLeftJoin(SelectExpression innerSelectExpression, SqlExpression joinPredicate, Type transparentIdentifierType)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

joinPredicate SqlExpression

A predicate to use for the join.

transparentIdentifierType Type

The type of the result generated after performing the join.

AddOuterApply(ShapedQueryExpression, Expression)

Adds the query expression of the given Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to table sources using OUTER APPLY and combine shapers.

public Expression AddOuterApply(ShapedQueryExpression innerSource, Expression outerShaper)

Parameters

innerSource ShapedQueryExpression

A Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression to join with.

outerShaper Expression

An expression for outer shaper.

Returns

Expression

An expression which shapes the result of this join.

AddOuterApply(SelectExpression)

Adds the given SelectExpression to table sources using OUTER APPLY.

public void AddOuterApply(SelectExpression innerSelectExpression)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

AddOuterApply(SelectExpression, Type)

Adds the given SelectExpression to table sources using OUTER APPLY.

[Obsolete("Use the other overloads.")]
public void AddOuterApply(SelectExpression innerSelectExpression, Type transparentIdentifierType)

Parameters

innerSelectExpression SelectExpression

A SelectExpression to join with.

transparentIdentifierType Type

The type of the result generated after performing the join.

AddSingleProjection(ShapedQueryExpression)

Adds a non-scalar single result to the projection of the SelectExpression.

public Expression AddSingleProjection(ShapedQueryExpression shapedQueryExpression)

Parameters

shapedQueryExpression ShapedQueryExpression

A shaped query expression for the subquery producing single non-scalar result.

Returns

Expression

A shaper expression to shape the result of this projection.

AddToProjection(EntityProjectionExpression)

Adds given EntityProjectionExpression to the projection.

public IDictionary<IProperty, int> AddToProjection(EntityProjectionExpression entityProjection)

Parameters

entityProjection EntityProjectionExpression

An entity projection to add.

Returns

IDictionary<IProperty, int>

A dictionary of Microsoft.EntityFrameworkCore.Metadata.IProperty to int indicating properties and their corresponding indexes in the projection list.

AddToProjection(SqlExpression)

Adds given SqlExpression to the projection.

public int AddToProjection(SqlExpression sqlExpression)

Parameters

sqlExpression SqlExpression

An expression to add.

Returns

int

An int value indicating the index at which the expression was added in the projection list.

AppendOrdering(OrderingExpression)

Appends ordering to the existing orderings of the SelectExpression.

public void AppendOrdering(OrderingExpression orderingExpression)

Parameters

orderingExpression OrderingExpression

An ordering expression to use for ordering.

ApplyCollectionJoin(int, int, Expression, INavigationBase, Type, bool)

Applies previously added collection projection.

public Expression ApplyCollectionJoin(int collectionIndex, int collectionId, Expression innerShaper, INavigationBase navigation, Type elementType, bool splitQuery = false)

Parameters

collectionIndex int

An int value specifing which collection from pending collection to apply.

collectionId int

An int value of unique collection id associated with this collection projection.

innerShaper Expression

A shaper expression to use for shaping the elements of this collection.

navigation INavigationBase

A navigation associated with this collection, if any.

elementType Type

The type of the element in the collection.

splitQuery bool

A value indicating whether the collection query would be run with a different DbCommand.

Returns

Expression

An expression which represents shaping of this collection.

ApplyDefaultIfEmpty(ISqlExpressionFactory)

Applies DefaultIfEmpty<TSource>(IQueryable<TSource>) on the SelectExpression.

public void ApplyDefaultIfEmpty(ISqlExpressionFactory sqlExpressionFactory)

Parameters

sqlExpressionFactory ISqlExpressionFactory

A factory to use for generating required sql expressions.

ApplyDistinct()

Applies DISTINCT operator to the projections of the SelectExpression.

public void ApplyDistinct()

ApplyExcept(SelectExpression, bool)

Applies EXCEPT operation to the SelectExpression.

public void ApplyExcept(SelectExpression source2, bool distinct)

Parameters

source2 SelectExpression

A SelectExpression to perform the operation.

distinct bool

A bool value indicating if resulting table source should remove duplicates.

ApplyGrouping(Expression)

Applies grouping from given key selector.

public void ApplyGrouping(Expression keySelector)

Parameters

keySelector Expression

An key selector expression for the GROUP BY.

ApplyIntersect(SelectExpression, bool)

Applies INTERSECT operation to the SelectExpression.

public void ApplyIntersect(SelectExpression source2, bool distinct)

Parameters

source2 SelectExpression

A SelectExpression to perform the operation.

distinct bool

A bool value indicating if resulting table source should remove duplicates.

ApplyLimit(SqlExpression)

Applies limit to the SelectExpression to limit the number of rows returned in the result set.

public void ApplyLimit(SqlExpression sqlExpression)

Parameters

sqlExpression SqlExpression

An expression representing limit row count.

ApplyOffset(SqlExpression)

Applies offset to the SelectExpression to skip the number of rows in the result set.

public void ApplyOffset(SqlExpression sqlExpression)

Parameters

sqlExpression SqlExpression

An expression representing offset row count.

ApplyOrdering(OrderingExpression)

Applies ordering to the SelectExpression. This overwrites any previous ordering specified.

public void ApplyOrdering(OrderingExpression orderingExpression)

Parameters

orderingExpression OrderingExpression

An ordering expression to use for ordering.

ApplyPredicate(SqlExpression)

Applies filter predicate to the SelectExpression.

public void ApplyPredicate(SqlExpression expression)

Parameters

expression SqlExpression

An expression to use for filtering.

ApplyProjection()

Adds expressions from projection mapping to projection if not done already.

public void ApplyProjection()

ApplyTags(ISet<string>)

Applies a given set of tags.

public void ApplyTags(ISet<string> tags)

Parameters

tags ISet<string>

A list of tags to apply.

ApplyUnion(SelectExpression, bool)

Applies UNION operation to the SelectExpression.

public void ApplyUnion(SelectExpression source2, bool distinct)

Parameters

source2 SelectExpression

A SelectExpression to perform the operation.

distinct bool

A bool value indicating if resulting table source should remove duplicates.

ClearOrdering()

Clears existing orderings.

public void ClearOrdering()

ClearProjection()

Clears all existing projections.

public void ClearProjection()

Equals(object)

public override bool Equals(object obj)

Parameters

obj object

Returns

bool

GetHashCode()

public override int GetHashCode()

Returns

int

GetMappedProjection(ProjectionMember)

Gets the projection mapped to the given Microsoft.EntityFrameworkCore.Query.ProjectionMember.

public Expression GetMappedProjection(ProjectionMember projectionMember)

Parameters

projectionMember ProjectionMember

A projection member to search in the mapping.

Returns

Expression

The mapped projection for given projection member.

IsNonComposedFromSql()

Checks whether this SelectExpression representes a FromSqlExpression which is not composed upon.

public bool IsNonComposedFromSql()

Returns

bool

A bool value indicating a non-composed FromSqlExpression.

PrepareForAggregate()

Prepares the SelectExpression to apply aggregate operation over it.

public void PrepareForAggregate()

Print(ExpressionPrinter)

protected override void Print(ExpressionPrinter expressionPrinter)

Parameters

expressionPrinter ExpressionPrinter

Prune()

This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

public SelectExpression Prune()

Returns

SelectExpression

PushdownIntoSubquery()

Pushes down the SelectExpression into a subquery.

public IDictionary<SqlExpression, ColumnExpression> PushdownIntoSubquery()

Returns

IDictionary<SqlExpression, ColumnExpression>

A mapping of projections before pushdown to ColumnExpressions after pushdown.

ReplaceProjectionMapping(IDictionary<ProjectionMember, Expression>)

Replaces current projection mapping with a new one to change what is being projected out from this SelectExpression.

public void ReplaceProjectionMapping(IDictionary<ProjectionMember, Expression> projectionMapping)

Parameters

projectionMapping IDictionary<ProjectionMember, Expression>

A new projection mapping.

ReverseOrderings()

Reverses the existing orderings on the SelectExpression.

public void ReverseOrderings()

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 SelectExpression Update(List<ProjectionExpression> projections, List<TableExpressionBase> tables, SqlExpression predicate, List<SqlExpression> groupBy, SqlExpression having, List<OrderingExpression> orderings, SqlExpression limit, SqlExpression offset)

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.

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

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.

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

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.

distinct bool

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.

VisitChildren(ExpressionVisitor)

protected override Expression VisitChildren(ExpressionVisitor visitor)

Parameters

visitor ExpressionVisitor

Returns

Expression