SelectExpression.AddLeftJoin Method

Definition

Namespace:

Microsoft.EntityFrameworkCore.Query.SqlExpressions

Assembly:

Microsoft.EntityFrameworkCore.Relational.dll

Package:

Microsoft.EntityFrameworkCore.Relational v9.0.0

Overloads

AddLeftJoin(SelectExpression, SqlExpression)	Adds the given SelectExpression to table sources using LEFT JOIN.
AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)	Adds the query expression of the given ShapedQueryExpression to table sources using LEFT JOIN and combine shapers.

AddLeftJoin(SelectExpression, SqlExpression)

Source:

SelectExpression.cs

Adds the given SelectExpression to table sources using LEFT JOIN.

public void AddLeftJoin (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression innerSelectExpression, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate);

member this.AddLeftJoin : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> unit

Public Sub AddLeftJoin (innerSelectExpression As SelectExpression, joinPredicate As SqlExpression)

Parameters

innerSelectExpression

SelectExpression

A SelectExpression to join with.

joinPredicate

SqlExpression

A predicate to use for the join.

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

Source:

SelectExpression.cs

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

public System.Linq.Expressions.Expression AddLeftJoin (Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression innerSource, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate, System.Linq.Expressions.Expression outerShaper);

member this.AddLeftJoin : Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Linq.Expressions.Expression -> System.Linq.Expressions.Expression

Public Function AddLeftJoin (innerSource As ShapedQueryExpression, joinPredicate As SqlExpression, outerShaper As Expression) As Expression

Parameters

innerSource

ShapedQueryExpression

A 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.