SelectExpression.AddLeftJoin Method
Definition
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
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
Entity Framework