title: Unable to use Contains in LINQ to Entity VS 2017 my query attached
body: <p>my query is,</p>
  
  <p>Here i am trying to get region id where the region name matches,</p>
  
  <pre><code>var Rid = db.Regions.Where(p =&gt; SqlFunctions.PatIndex("%" + Search + "%", p.RegionName) &gt; 0).Select(p =&gt; p.RegionId).ToList();
  </code></pre>
  
  <p>Change Id's comma separated in string,</p>
  
  <pre><code>string joined = string.Join(",", Rid);
  </code></pre>
  
  <p>Trying to get all records related to Id's comma separated in <code>string joined</code></p>
  
  <pre><code>var employ = db.Employees.Include(f =&gt; f.City).Include(f =&gt; f.Region).Where(p=&gt;p.RegionId);
  </code></pre>
  
  <p>Issue is that we dont have contain when i tried use in where clause ??</p>
  
  <p>Hopes for your suggestions</p>