title: How to compare string with DateTime in Entity Framework
body: <p>I've an Entity framework schema as below.</p>
  
  <pre><code>Class Contact
  { 
     string name;
     DateTime creationDate;
  }
  and i've a string that is
  
  string date="9/9/14 3:00:00 PM"
  </code></pre>
  
  <p>i am executing foll0wing query</p>
  
  <pre><code>var q=from u in db.Contacts where u.creationDate.ToString==date select u;
  </code></pre>
  
  <p>but i am facing the following error </p>
  
  <p>LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.</p>
  
  <p>can any one tell me how can i compare dateTime with string ? what are the possible casting?</p>