title: How to Compare strings by Regex inside a LINQ Query?
body: <p>I have two datatables dtRosterList and falsefields
  I want to list out all rosterlist against falsefields ,where list column value is a sentence "Hello i am a list of field" and falsefields column value having a single string "field"...i am matching by Regex.IsMatch</p>
  
  <pre><code>Regex.IsMatch(r.Field&lt;string&gt;("ListName"),@"\bFacebook Link\b") 
  </code></pre>
  
  <p>is returning true in the Visual studio intermediate window but 
  Regex.IsMatch(r.Field("ListName"),@"\b"+fn+"\b") is coming false in Linq query itself and i am getting no rows...The query is below:</p>
  
  <pre><code>   var listTobeDeleted = dtRosterList.AsEnumerable().
                               Where(r =&gt; falsefields.AsEnumerable()
                                   .Select(f =&gt; f.Field&lt;string&gt;("FieldName")).Any(fn =&gt; Regex.Match(r.Field&lt;string&gt;("ListName"),@"\b"+fn+"\b",RegexOptions.IgnoreCase))).CopyToDataTable();
  </code></pre>