SelectExpression.AddInnerJoin Method

Definition

Namespace:: Microsoft.EntityFrameworkCore.Query.SqlExpressions

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

Package:: Microsoft.EntityFrameworkCore.Relational v10.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v11.0.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

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

Name	Description
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(ShapedQueryExpression, SqlExpression, Expression, Boolean, Boolean)	Adds the query expression of the given ShapedQueryExpression to table sources using INNER JOIN and combine shapers.

AddInnerJoin(SelectExpression, SqlExpression)

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

Source:: SelectExpression.cs

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)

Source:: SelectExpression.cs

Source:: SelectExpression.cs

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 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)

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

AddInnerJoin(ShapedQueryExpression, SqlExpression, Expression, Boolean, Boolean)

Source:: SelectExpression.cs

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, bool toOneJoin = false, bool prunableJoin = false);

member this.AddInnerJoin : Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Linq.Expressions.Expression * bool * bool -> System.Linq.Expressions.Expression

Public Function AddInnerJoin (innerSource As ShapedQueryExpression, joinPredicate As SqlExpression, outerShaper As Expression, Optional toOneJoin As Boolean = false, Optional prunableJoin As Boolean = false) 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.

toOneJoin: Boolean

Whether each outer row is guaranteed to match at most one inner row. When true, inner identifiers are not added (#29182).

prunableJoin: Boolean

Whether the join can be pruned if none of its columns are referenced. For INNER JOINs this requires both a to-one guarantee and a required foreign key guaranteeing matching rows exist (#29182).

Returns

Expression

An expression which shapes the result of this join.

Applies to

Comentarios

¿Le ha resultado útil esta página?