title: LINQ convert DateTime to string
body: <pre><code>List&lt;Post&gt; list =
  (
      from c in db.TitleComments
      join t in db.Titles on c.TitleId equals t.Id
      join u in db.Users on c.UserId equals u.Id
      where t.Id == _titleId &amp;&amp; c.Date &gt; time
      orderby c.Date descending
      select new Post { Username = u.Username, PostingDate = c.Date.ToString(), Data = c.Comment }
  ).ToList();
  </code></pre>
  
  <p>The code above causes exception on the convertion of date to string, PostingDate = c.Date.ToString(). Any ideas how to get around this?</p>
  
  <p>Exception error:
  {"LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression."}</p>