title: Linq query from datasource with where ... like '%%' or ... like '%%'
body: <p>I'm trying to select all the fields from a db that contains any of the string contained in a list (that could be populated from user).
  Is very easy for me to do by pure SQL with a sentence like</p>
  
  <pre><code>WHERE myfield LIKE '%nam%' OR myfield LIKE '%cod%' OR myfield LIKE '%big%'
  </code></pre>
  
  <p>but I need to do it with C# and Linq. I searched several solutions, some that recommend me to use .Any or .Contains but I didn't get it how to apply to my case :-(</p>
  
  <p>This is the most close result I can achieve:</p>
  
  <pre><code>var query = DataSource.Docs();
  
  ...
  
  IList&lt;string&gt; nameFilter = new List&lt;string&gt;() {"nam", "cod", "big"};                    
  query = query.Where(x =&gt; x.NomeFile.Contains(nameFilter.FirstOrDefault()));
  </code></pre>
  
  <p>anyway with this silly code I filter just the elements are containing the first element of my list (the FirstOrDefault let ignore all the others)</p>
  
  <p>Can anybody help me to find the right way?</p>