title: LINQ to SQL Custom Property query on where clause
body: <p>I am using <a href="http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL" rel="nofollow noreferrer">LINQ to SQL</a> classes, and have extended one (with a partial class) and added an extra property.  I want to query on this property, so:</p>
  
  <pre><code>(from p in db.TableName where p.CustomProperty=="value" select p)
  </code></pre>
  
  <p>However this doesn't work. I get an error: <code>The member 'TableName.CustomProperty' has no supported translation to SQL</code>.  At the moment I have no code in the 'set' section of my Custom Property as I'm unsure how.</p>
  
  <p>So basically, Custom Property which can be queried on with LINQ to SQL, how?  </p>
  
  <p>As a follow up: this CustomProperty is NOT a column in the table. It is a separate value, but I need to both fetch it (easy enough) but also query on it!</p>