Share via

SelectExpression.AddLeftJoin Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore.Query.SqlExpressions
Assembly:
Microsoft.EntityFrameworkCore.Relational.dll
Package:
Microsoft.EntityFrameworkCore.Relational v3.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v3.1.0
Package:
Microsoft.EntityFrameworkCore.Relational v5.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v6.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v7.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v8.0.0

Overloads

AddLeftJoin(SelectExpression, SqlExpression, Type)
Obsolete.

Adds the given SelectExpression to table sources using LEFT JOIN.
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)

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
ObsoleteAttribute

Applies to

AddLeftJoin(SelectExpression, SqlExpression)

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)

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.

Applies to