title: How to do dynamic comparison in Linq to SQL with a string field?
body: <p>How to do dynamic comparison in Linq to SQL with a string field for obtain a query like:</p>
  
  <pre><code>"SELECT COLUMN_1, COLUMN_2" +
  "FROM "+ stringTABLE +
  "WHERE " + stringCOLUMN_1_or2  + " = ' " + 8 + "'";
  </code></pre>
  
  <p>I know that i can this:</p>
  
  <pre><code>from x in objects
  where x.COLUMN_1 == "8"
  select x
  </code></pre>
  
  <p>but the FIELD is variable, can be COLUMN_1 or COLUMN_2" or other...</p>
  
  <p>as an example of what I want to do in Windows Forms (framework 4.0)</p>
  
  <pre><code>from x in objets
  where x.field[stringCOLUMN_1_or2] == "8"
  select x
  </code></pre>
  
  <p>how I can do this?
  thanks in advance</p>