Share via


SelectExpression.AddLeftJoin Method

Definition

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, Type)
Obsolete.

Adds the given SelectExpression to table sources using LEFT JOIN.

AddLeftJoin(SelectExpression, SqlExpression)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
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.

Applies to

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
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

An expression which shapes the result of this join.

Applies to

AddLeftJoin(SelectExpression, SqlExpression, Type)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs

Caution

Use the other overloads.

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, Type transparentIdentifierType);
[System.Obsolete("Use the other overloads.")]
public void AddLeftJoin (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression innerSelectExpression, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate, Type transparentIdentifierType);
[System.Obsolete("Use the other overloads.")]
public void AddLeftJoin (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression innerSelectExpression, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate, Type? transparentIdentifierType);
member this.AddLeftJoin : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Type -> unit
[<System.Obsolete("Use the other overloads.")>]
member this.AddLeftJoin : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Type -> unit
Public Sub AddLeftJoin (innerSelectExpression As SelectExpression, joinPredicate As SqlExpression, transparentIdentifierType As Type)

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.

Attributes

Applies to