views:

35

answers:

0

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