Прочетете на английски Редактиране

Споделяне чрез


DbExpressionBuilder.FullOuterJoin Method

Definition

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

Overloads

FullOuterJoin(DbExpression, DbExpression, Func<DbExpression,DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

FullOuterJoin(DbExpressionBinding, DbExpressionBinding, DbExpression)

Creates a new DbJoinExpression that joins the sets specified by the left and right expression bindings, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

FullOuterJoin(DbExpression, DbExpression, Func<DbExpression,DbExpression,DbExpression>)

Creates a new DbJoinExpression that joins the sets specified by the left and right expressions, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

C#
public static System.Data.Common.CommandTrees.DbJoinExpression FullOuterJoin(this System.Data.Common.CommandTrees.DbExpression left, System.Data.Common.CommandTrees.DbExpression right, Func<System.Data.Common.CommandTrees.DbExpression,System.Data.Common.CommandTrees.DbExpression,System.Data.Common.CommandTrees.DbExpression> joinCondition);

Parameters

left
DbExpression

A DbExpression that specifies the left set argument.

right
DbExpression

A DbExpression that specifies the right set argument.

joinCondition
Func<DbExpression,DbExpression,DbExpression>

A method representing the condition on which to join. This method must produce an expression with a Boolean result type that provides the logic of the join condition.

Returns

A new DbJoinExpression, with an DbExpressionKind of FullOuterJoin, that represents the full outer join operation applied to the left and right input sets under the given join condition.

Exceptions

left, right or joinCondition is null.

-or-

The expression produced by joinCondition is null.

left or right does not have a collection result type.

-or-

The expression produced by joinCondition does not have a Boolean result type.

Applies to

.NET Framework 4.8.1 и други версии
Продукт Версии
.NET Framework 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1

FullOuterJoin(DbExpressionBinding, DbExpressionBinding, DbExpression)

Creates a new DbJoinExpression that joins the sets specified by the left and right expression bindings, on the specified join condition, using FullOuterJoin as the DbExpressionKind.

C#
public static System.Data.Common.CommandTrees.DbJoinExpression FullOuterJoin(this System.Data.Common.CommandTrees.DbExpressionBinding left, System.Data.Common.CommandTrees.DbExpressionBinding right, System.Data.Common.CommandTrees.DbExpression joinCondition);

Parameters

left
DbExpressionBinding

An DbExpressionBinding that specifies the left set argument.

right
DbExpressionBinding

An DbExpressionBinding that specifies the right set argument.

joinCondition
DbExpression

An expression that specifies the condition on which to join.

Returns

A new DbJoinExpression, with an DbExpressionKind of FullOuterJoin, that represents the full outer join operation applied to the left and right input sets under the given join condition.

Exceptions

left, right or joinCondition is null.

The expression produced by joinCondition does not have a Boolean result type.

Applies to

.NET Framework 4.8.1 и други версии
Продукт Версии
.NET Framework 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1