title: LINQ to Entities does not recognize the method 'System.DateTime Parse(System.String)' method
body: <p>I'm a newbie to Linq and the below query keeps returning "does not recognize System.DateTime" error.  I've tried Parse and Convert and neither works.  Here's my query:</p>
  
  <p>mrcEntities context = GetContext();</p>
  
  <pre><code>        var query = from c in context.tblClients
                      where (c.FirstName != null || c.LastName != null)
                         &amp;&amp; c.EligibilityDate &gt;= DateTime.Parse("10/01/2011")
                         &amp;&amp; c.EligibilityDate &lt;= DateTime.Parse("04/30/2012")
                        orderby c.ClientID
                      select new
                      {
                          ClientID = c.ClientID,
                          FirstName = c.FirstName,
                          LastName = c.LastName,
                          MiddleName = c.MidName,
                          SSN = c.SSN,
                          DOB = c.DOB,
                          Sex = c.Gender,
                          Ethnic = c.EthnicCode
                      };
  
          clientRowCnt = query.Count();
  </code></pre>
  
  <p>Any help would be appreciated.</p>