title: How to filter records on a string date column using entity framework
body: <p>I have a SQL server database table that has a DueDate column. Data type of this column is nvarchar(50) and thus it saves dates values as string into this column. </p>
  
  <p>I am using entity framework to get records from this table. My requirement is to get only those records whose DueDate is elapsed i.e records where DueDate &lt;= TodaysDate. But as Linq to Entities does not support Covert.ToString() or Covert.ToDateTime() methods therefore I cannot compare the DueDate values with today's date value.</p>
  
  <p>Kindly help me in fixing this problem.</p>
  
  <p>Thanks in advance.</p>