How to Convert SQL to Linq for multiple on clause

See more:

SQL

LINQ

Hi All,

I want to convert below sql to linq, Multiple on clause in join statements

select * from dbo.Table1              	 
LEFT OUTER JOIN dbo.Table2 AS Table2                     	 
INNER JOIN dbo.Table3 AS Table3 ON Table3.Id = Table2.LnId 
 ON Table2.Id = Table1.Column1 

This is my linq Statement

 from Table1 in ctxk.Table1
join Table2 in ctx.Table2 on  equals  into ExternalPerson_join
from Table2 in ExternalPerson_join.DefaultIfEmpty()
join Table3 in ctxk.Table3 
on  new 
{ 
aid = Table2.LnId, 
bid = Table2.Id  
}	
	equals 
	new 
	{
	aid = Table3.Id, 
	bid = Table1.LnId   
	}
select new {
  Table1,
  Table2,
  Table3
}

linq statement raises error
"Invalid expression term 'equals'
Expected contextual keyword 'equals'"

How to fix it

Thank you