title: Use contains in LINQ to SQL join
body: <p>How can I do a LINQ to SQL join without an exact match? For example, say I have a table <code>form</code> with the data <code>John Smith (2)</code> and I want to join it to the field <code>Smith</code> in table <code>name</code>. Something like this</p>
  
  <pre><code>var query =
      from f in db.form
      join n in db.name
          on f.nameField like '%' + n.firstName + '%'
  </code></pre>
  
  <p>Although the <code>like</code> keyword doesn't seem to be available to me.</p>