title: iterate over fields using linq
body: <p>I've got a table with alot of columns and want to concaternate all the string fields in a row together so I can perform a search through it without comparing the search string to each field in turn. </p>
  
  <p>How do I iterate through the row without explicitly stating each column name?</p>
  
  <pre><code>ColumnA | ColumnB | ... | ColumnN
  ---------------------------------
     A    |    B    | ... |    N   
  </code></pre>
  
  <p>I would like to get the result AB...N</p>
  
  <p>This is what I have so far</p>
  
  <pre><code>string searchString = "text";
  var searchCandidate = ATable.Where( ... condition ...); // IQueryable&lt;ATable&gt;
  searchCandidate. // what goes here to loop through all fields ?
  </code></pre>