title: LINQ LEFT JOIN where clause not working
body: <p>I need to return a list of all the events and any rsvps a user may have for an event. However, regardless of the username I pass, It returns every single rsvp. My linq Query ->  </p>
  
  <pre><code>   return (from events in this._context.Context.Events
             join rsvps in (this._context.Context.RSVPs
                            .Where(o=&gt; o.UserName == userName))
             on events equals rsvps.Event into re
             from rsvps in re.DefaultIfEmpty()
             select events);
  </code></pre>
  
  <p>Relationship is<br>
      Events.EventID = RSVPs.EventID</p>