DbExpressionBuilder.FullOuterJoin 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.
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.
public:
[System::Runtime::CompilerServices::Extension]
static System::Data::Common::CommandTrees::DbJoinExpression ^ FullOuterJoin(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);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);static member FullOuterJoin : System.Data.Common.CommandTrees.DbExpression * System.Data.Common.CommandTrees.DbExpression * Func<System.Data.Common.CommandTrees.DbExpression, System.Data.Common.CommandTrees.DbExpression, System.Data.Common.CommandTrees.DbExpression> -> System.Data.Common.CommandTrees.DbJoinExpression<Extension()>
Public Function FullOuterJoin (left As DbExpression, right As DbExpression, joinCondition As Func(Of DbExpression, DbExpression, DbExpression)) As DbJoinExpressionParameters
- 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
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.
public:
[System::Runtime::CompilerServices::Extension]
static System::Data::Common::CommandTrees::DbJoinExpression ^ FullOuterJoin(System::Data::Common::CommandTrees::DbExpressionBinding ^ left, System::Data::Common::CommandTrees::DbExpressionBinding ^ right, System::Data::Common::CommandTrees::DbExpression ^ joinCondition);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);static member FullOuterJoin : System.Data.Common.CommandTrees.DbExpressionBinding * System.Data.Common.CommandTrees.DbExpressionBinding * System.Data.Common.CommandTrees.DbExpression -> System.Data.Common.CommandTrees.DbJoinExpression<Extension()>
Public Function FullOuterJoin (left As DbExpressionBinding, right As DbExpressionBinding, joinCondition As DbExpression) As DbJoinExpressionParameters
- 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for