title: error Unknown column 'Extent1.id' in 'where clause' within where of list in mysql & EF6
body: <p>I use Mysql WorkBench and Entity framework 6. I want to add the condition "where" for previously query. if I add condition for <strong>simple attribute</strong> (<code>string</code>), it successfully. But I add condition for <code>List&lt;object&gt;</code>, it is the error message "<strong>Unknown column 'Extent1.id' in 'where clause'</strong>.</p>
  
  <p>How can i add condition for query, with condition is list</p>
  
  <p>Query select:</p>
  
  <pre><code>var result = from mus in ct.musics
       where  mus.state == Contant.Keys.StateAction.A.ToString()
       select (new
       {
             MusicKey = mus.id,
             OptionKey = mus.musicoptions.Select(i =&gt; i.OptionsId),
       });
  </code></pre>
  
  <p>after i add another <strong>Where(List)</strong> for <strong>result</strong>. <em>it is error Unknown column 'Extent1.id' in 'where clause</em></p>
  
  <pre><code> foreach (ClassOption obj in request.Options)
         {
              if (obj.type.ToString() == "opt")
               {
  
                 string a = obj.key.ToString();
                 result = result.Where(i =&gt; i.OptionKey.ToList().Contains(a));
               }
          }
  </code></pre>
  
  <p>but i add another <strong>Where(simple)</strong> for <strong>result</strong>. <em>it is success</em></p>
  
  <pre><code>foreach (ClassOption obj in request.Options)
             {
                  if (obj.type.ToString() == "opt")
                   {
  
                     string a = obj.key.ToString();
                     result = result.Where(i =&gt; i.MusicKey == "test");
                   }
              }
  </code></pre>
  
  <p><em>note</em>: before I used ms sql 2008 and EF6 the previous statement can run, but when I  changed to use mysql, it was an error.</p>