title: Simple left join in LINQ
body: <p>I have a Private-Message Table and a User-Table.</p>
  
  <p>I connect them here:</p>
  
  <pre><code> var messageUsers = (from pm in dc.PrivateMessages
                                  join user in dc.Users
                                  on pm.SenderID equals user.UserID
                                  where !pm.IsDeletedRecipient &amp;&amp; pm.RecipientID == id
                                  select new PMInbox
                                  {
                                      SenderUsername = user.Username,
                                      PrivateMessageID = pm.PrivateMessageID,
                                      SenderID = pm.SenderID,
                                      Subject = pm.Subject,
                                      Text = pm.Text,
                                      SenderType = pm.SenderType,
                                      IsDeletedRecipient = pm.IsDeletedRecipient,
                                      IsDeletedSender = pm.IsDeletedSender,
                                      IsRead = pm.IsRead,
                                      Timestamp = pm.TimestampSend
  
                                  }).ToList();
  </code></pre>
  
  <p>How to make this in a left-join, so if the userID is not the SenderID (e.g. The Sender is deleted allready), the Username should be empty?</p>