Left join LINQ

Question

Hello

I want to write left join by linq and fill a view by out but of this left join.

 

my left join is like below

 

select table1.a, table1.b,table2.c

from table1 left join table2

on table1.a=table2.c

where table2.g="123" or table2.g==null

 

 

as I said want to put output of this join to a view.

Thanks for your help.