Add support of Left Joins to Linq Provider

Description

The attached sample identifies a number of issues in the LINQ provider related to the use of the "Join" expression. Specifically when performing outer joins or pre filtering the result set to be join in the join.

for example

select *
from table 1 a
left join table 2 b
on a.id = b.id
and b.start_date < getdate()

Environment

None

Status

Assignee

Unassigned

Reporter

Alex Baker

Labels

Components

Affects versions

3.0.0.Beta1

Priority

Major