title: Join With List Collection
body: <p>I try to write a join LINQ query. but it's raise syntax error. what can i do? i need user's conversation messages.</p>
  
  <pre><code>/*
  Conversations = Header info
  c.Users = List&lt;ApplicationUser&gt;
  */
  public List&lt;ConversationMessage&gt; GetAll(ApplicationUser user)
  {
      var query = from m in _db.ConversationMessages
          join c in _db.Conversations on m.ConversationId equals c.ConversationId
          join u in _db.Users on c.Users.Contains(user) 
          select m;
  }
  </code></pre>