语言

SelectExpression.AddLeftJoin 方法

定义

重载

名称 说明
AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression, Boolean, Boolean)

使用 LEFT JOIN 将给定 ShapedQueryExpression 的查询表达式添加到表源,并合并整形程序。

AddLeftJoin(SelectExpression, SqlExpression)

使用 LEFT JOIN 将给定 SelectExpression 添加到表源。

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

使用 LEFT JOIN 将给定 ShapedQueryExpression 的查询表达式添加到表源,并合并整形程序。

AddLeftJoin(SelectExpression, SqlExpression, Type)
已过时.

使用 LEFT JOIN 将给定 SelectExpression 添加到表源。

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression, Boolean, Boolean)

Source:
SelectExpression.cs

使用 LEFT JOIN 将给定 ShapedQueryExpression 的查询表达式添加到表源,并合并整形程序。

[Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkInternal]
public System.Linq.Expressions.Expression AddLeftJoin(Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression innerSource, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression joinPredicate, System.Linq.Expressions.Expression outerShaper, bool toOneJoin, bool prunableJoin);
[<Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkInternal>]
member this.AddLeftJoin : Microsoft.EntityFrameworkCore.Query.ShapedQueryExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Linq.Expressions.Expression * bool * bool -> System.Linq.Expressions.Expression
Public Function AddLeftJoin (innerSource As ShapedQueryExpression, joinPredicate As SqlExpression, outerShaper As Expression, toOneJoin As Boolean, prunableJoin As Boolean) As Expression

参数

innerSource
ShapedQueryExpression

要加入的 A ShapedQueryExpression 。

joinPredicate
SqlExpression

要用于联接的谓词。

outerShaper
Expression

外部整形器的表达式。

toOneJoin
Boolean

是否保证每个外部行最多匹配一个内部行。 如果未 true添加内部标识符,则不会添加内部标识符。

prunableJoin
Boolean

如果未引用任何列(#29182),是否可以修剪联接。

返回

一个表达式,用于塑造此联接的结果。

特性

适用于

AddLeftJoin(SelectExpression, SqlExpression)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs

使用 LEFT JOIN 将给定 SelectExpression 添加到表源。

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)

参数

innerSelectExpression
SelectExpression

要加入的 A SelectExpression 。

joinPredicate
SqlExpression

要用于联接的谓词。

适用于

AddLeftJoin(ShapedQueryExpression, SqlExpression, Expression)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs

使用 LEFT JOIN 将给定 ShapedQueryExpression 的查询表达式添加到表源,并合并整形程序。

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

参数

innerSource
ShapedQueryExpression

要加入的 A ShapedQueryExpression 。

joinPredicate
SqlExpression

要用于联接的谓词。

outerShaper
Expression

外部整形器的表达式。

返回

一个表达式,用于塑造此联接的结果。

适用于

AddLeftJoin(SelectExpression, SqlExpression, Type)

Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs
Source:
SelectExpression.cs

注意

Use the other overloads.

使用 LEFT JOIN 将给定 SelectExpression 添加到表源。

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)

参数

innerSelectExpression
SelectExpression

要加入的 A SelectExpression 。

joinPredicate
SqlExpression

要用于联接的谓词。

transparentIdentifierType
Type

执行联接后生成的结果的类型。

特性

适用于