DbExpressionBuilder.LeftOuterJoin Method

Definition

Namespace:

System.Data.Common.CommandTrees.ExpressionBuilder

Assembly:

System.Data.Entity.dll

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

Overloads

LeftOuterJoin(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 LeftOuterJoin as the DbExpressionKind.
LeftOuterJoin(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 LeftOuterJoin as the DbExpressionKind.

LeftOuterJoin(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 LeftOuterJoin as the DbExpressionKind.

public:
[System::Runtime::CompilerServices::Extension]
 static System::Data::Common::CommandTrees::DbJoinExpression ^ LeftOuterJoin(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 LeftOuterJoin (this System.Data.Common.CommandTrees.DbExpressionBinding left, System.Data.Common.CommandTrees.DbExpressionBinding right, System.Data.Common.CommandTrees.DbExpression joinCondition);

static member LeftOuterJoin : System.Data.Common.CommandTrees.DbExpressionBinding * System.Data.Common.CommandTrees.DbExpressionBinding * System.Data.Common.CommandTrees.DbExpression -> System.Data.Common.CommandTrees.DbJoinExpression

<Extension()>
Public Function LeftOuterJoin (left As DbExpressionBinding, right As DbExpressionBinding, joinCondition As DbExpression) As DbJoinExpression

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

DbJoinExpression

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

Exceptions

ArgumentNullException

left, right or joinCondition is null.

ArgumentException

joinCondition does not have a Boolean result type.

LeftOuterJoin(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 LeftOuterJoin as the DbExpressionKind.

public:
[System::Runtime::CompilerServices::Extension]
 static System::Data::Common::CommandTrees::DbJoinExpression ^ LeftOuterJoin(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 LeftOuterJoin (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 LeftOuterJoin : 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 LeftOuterJoin (left As DbExpression, right As DbExpression, joinCondition As Func(Of DbExpression, DbExpression, DbExpression)) As DbJoinExpression

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

DbJoinExpression

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

Exceptions

ArgumentNullException

left, right or joinCondition is null.

-or-

The expression produced by joinCondition is null.

ArgumentException

left or right does not have a collection result type.

-or-

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