SelectExpression.AddInnerJoin 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 v3.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v3.1.0

Overloads

AddInnerJoin(SelectExpression, SqlExpression)

Adds the given SelectExpression to table sources using INNER JOIN.
AddInnerJoin(ShapedQueryExpression, SqlExpression, Expression)

Adds the query expression of the given ShapedQueryExpression to table sources using INNER JOIN and combine shapers.
AddInnerJoin(SelectExpression, SqlExpression, Type)
Obsolete.

Adds the given SelectExpression to table sources using INNER JOIN.

AddInnerJoin(SelectExpression, SqlExpression)

Adds the given SelectExpression to table sources using INNER JOIN.

public void AddInnerJoin (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression innerSelectExpression, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate);
member this.AddInnerJoin : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> unit
Public Sub AddInnerJoin (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

AddInnerJoin(ShapedQueryExpression, SqlExpression, Expression)

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

public System.Linq.Expressions.Expression AddInnerJoin (Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression innerSource, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate, System.Linq.Expressions.Expression outerShaper);
member this.AddInnerJoin : Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Linq.Expressions.Expression -> System.Linq.Expressions.Expression
Public Function AddInnerJoin (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

AddInnerJoin(SelectExpression, SqlExpression, Type)

Caution

Use the other overloads.

Adds the given SelectExpression to table sources using INNER JOIN.

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