SelectExpression.AddLeftJoin Method

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore.Query.SqlExpressions

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

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

Package:: Microsoft.EntityFrameworkCore.Relational v9.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.1.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

Entity Framework Core 9.0 y otras versiones

Producto	Versiones
Entity Framework Core	5.0, 6.0, 7.0, 8.0, 9.0

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

Expression

An expression which shapes the result of this join.

Applies to

Entity Framework Core 9.0 y otras versiones

Producto	Versiones
Entity Framework Core	5.0, 6.0, 7.0, 8.0, 9.0

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: ObsoleteAttribute

Applies to

Entity Framework Core 6.0 y otras versiones

Producto	Versiones (Obsoleto)
Entity Framework Core	3.0, 3.1 (5.0, 6.0)

Compartir a través de

SelectExpression.AddLeftJoin Method

Definition

Overloads

AddLeftJoin(SelectExpression, SqlExpression)

Parameters

Applies to

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

Parameters

Returns

Applies to

AddLeftJoin(SelectExpression, SqlExpression, Type)

Parameters

Applies to

Recursos adicionales