title: How can I convert a DateTime variable in a LINQ expression?
body: <p>Given this expression:</p>
  
  <pre><code>var q = (from c in db.ContattiTitoliStudio
                       where ...
                       orderby c.Data descending
                       select new
                       {
                           c.ID,
                           Date = c.Data.ToString("MM dd, YYYY"),
                       });
  </code></pre>
  
  <p><code>c.Data is nullable</code>, but also with a non-nullable var is the same:
  "<code>...No overload for method 'ToString' takes 1 arguments...</code>"</p>
  
  <p>I tried <code>nullable</code>, not nullable, with <code>(c.Data!=null)...</code>, with <code>String.Format</code>, with <code>DateTime.Parse</code>, etc... But I can't format <code>c.Date</code> the way I want.</p>
  
  <p>In SQL Server I use <code>datetime</code> as the type.</p>
  
  <p>If I use normal <code>Date = c.Date</code> this will be displayed as "01/01/2011 0.0.00".</p>