Can any one tell me the LINQ 2 SQL version (in vb.net) of the below Left outer join query.I am trying to get all Employees with name "Shyju" and their address line 1 if it exist in the address table
SELECT E.EMPLOYEE_NAME,
E.AGE,A.ADRESS_LINE1
FROM EMPLOYEE_MASTER E
LEFT OUTER JOIN
ADDRESS_MASTER A
ON E.ID=A.EMPLOYEE_ID
WHERE E.EMPLOYEE_NAME='Shyju'
Thanks in advance