title: Nested query in entity framework
body: <p>I am getting the following exception:</p>
  
  <blockquote>
    <p>The nested query is not supported. Operation1='Case' Operation2='Collect'</p>
  </blockquote>
  
  <p>with this query</p>
  
  <pre><code>var Games = context.Games.Select(a =&gt; new GameModel
  {
       Members = (a.Type == 1 ? (a.UsersInGames.Where(b =&gt; b.GameID == a.ID &amp;&amp; b.StatusID == 1).Select(c =&gt; new Member
       {
           ID = c.UserID,
           email = c.UserInfo.EmailAddress,
           screenName = c.UserInfo.ScreenName
       })) :   
      (a.Teams.Where(b =&gt; b.GameID == a.ID).SelectMany(b =&gt; b.UsersInTeams.Where(c =&gt; c.StatusID == 1)).Select(d =&gt; new Member
      {
          ID = d.UserID,
          email = d.UserInfo.EmailAddress,
          screenName = d.UserInfo.ScreenName
      )))
  })
  </code></pre>
  
  <p>when I don't include the condition in selecting Members, the query works fine. Is there a way I can do the conditional inside the query?</p>