How do I write the equivalent of a SQL LEFT JOIN in LINQ?
11:05 19 Apr 2013

I need to convert this SQL to LINQ:

SELECT * FROM Adx_eventSet AS es
LEFT JOIN afx_eventsponsor_eventSet AS spon
ON es.Adx_eventId = spon.adx_eventid

I've tried this but it's not a left join and so only pulled in the one result.

from t in Adx_eventSet
join x in adx_eventsponsor_eventSet on t.Adx_eventId equals x.adx_eventid
select t
sql linq