title: Entity Framework - failed cast string to datetime on exec stored procedure
body: <p>So, I am really new to EF, an the problem a bit complicated for me.</p>
  
  <p>Here is the data returned by my stored procedure:</p>
  
  <pre><code>[Date]     [Name]
  8/31/2012  John Doe
  8/12/2011  John Meyer
  </code></pre>
  
  <p>My entity is:</p>
  
  <pre><code>public class UserEntity
  {
     public DateTime Date {get; set;}
     public string Name {get; set;}
  }
  </code></pre>
  
  <p>when I change <code>Date</code> into <code>string</code> it is working fine.</p>
  
  <p>I used </p>
  
  <pre><code>Database.SqlQuery&lt;UserEntity&gt;("exec sp_name", /*params*/)
  </code></pre>
  
  <p>to get the list.</p>
  
  <p>Another problem that make it more complicated: stored procedure and entity are legacy code, used in different project so it is impossible to change.</p>
  
  <p>Is there any chance for me to solve the case?</p>