title: Illegal mix of collations for operation ' IN ', While using LINQ Lambda with contains clause
body: <p>I am having <code>Linq</code> query that fetch city names as keyValue pair, Refer below code</p>
  <pre><code> public List&lt;KeyValuePair&lt;string, int&gt;&gt; GetCityKeyValuesByNames(List&lt;string&gt; cityNames)
          {
             
                  var cityList = _cityRepo
                      .GetConditionalQuery(x =&gt; cityNames.Contains(x.Name))
                      .Select(x =&gt; new { Key = x.Name, Value = x.Id })
                      .AsEnumerable()
                      .Select(x =&gt; new KeyValuePair&lt;string, int&gt;(x.Key, x.Value))
                      .ToList();
  
                  return cityList;                
          }
  </code></pre>
  <p>However we getting Eception <code>MySql.Data.MySqlClient.MySqlException: Illegal mix of collations for operation ' IN '</code>, How I can control the collation in EF Linq query?</p>