title: Query with left join in linq
body: <p>Hello I 'm trying to do a query in linq but I think I need some help...</p>
  
  <p>I have two table: langAvailable and Translations
  I want a 'line' even if theres no translation recorded</p>
  
  <p>For instance:  </p>
  
  <pre><code>           LangId: 1  TranslationID:10  Translation: Hello
             LangId: 2  TranslationID:10  Translation: Bonjour
             LangId: 1  TranslationID:11  Translation: Thanks
             LangId: 2  TranslationID:11  Translation: 
  </code></pre>
  
  <p>Here's what I do:</p>
  
  <pre><code> Dim query = From c In db.LangAvailable _
               Join o In db.Translate On c.ID_Lang Equals o.Lang_ID _
               Where o.TranslationID = 243 _
               Select New With {c.LangId, o.Translation}
  </code></pre>
  
  <p>This only give me one record if there s no translation in the translate table...
  Any idea how I can get that?</p>
  
  <p>Thanx</p>