title: Entity Framework Many to Many query
body: <p>I want to write a simple query, but there are some problems.
  I have 2 tables M to N:</p>
  
  <p>Users -> Events.</p>
  
  <p>I want to get all users of a specific event (get this event by eventId).</p>
  
  <pre><code>public IQueryable&lt;User&gt; GetUsersByEventId(int eventId)
  {
      IQueryable&lt;User&gt; query = this.Context.Users.AsQueryable();
  
      return query.Where(x =&gt; x.Events.SingleOrDefault(e =&gt; e.EventId == eventId)); ??
  }
  </code></pre>
  
  <p>Something is missing and I dont know what, can someone help me? Thanks a lot !</p>