title: Having trouble with a many to many linq select
body: <p>I have three tables created as so:</p>
  
  <p><img src="https://i.stack.imgur.com/Vxxek.png" alt="enter image description here"></p>
  
  <p>What I'd like to do is select an Attendee where an AdministratorAttendee record exists for a given AttendeeId and AdministratorId.</p>
  
  <p>What I've tried is this:</p>
  
  <pre><code>var result = (from a in dc.Attendees
                from aa in dc.AdministratorAttendees
                where aa.AdministratorId == this.CurrentAdminId &amp;&amp; a.AttendeeId == _attendee.AttendeeId
                select a);
  </code></pre>
  
  <p>But it's returning no results despite the fact an Attendee, Administrator and AdministratorAttendee record exists for the given Ids.</p>
  
  <p>What is the correct linq query to use?</p>
  
  <p>Thanks</p>