title: SQLite DATETIME column with Entity Framework
body: <p>I have an existing SQLite database that I want to use in Entity Framework. However SQLite's weird type system means you can even</p>
  
  <pre><code>create table temp(temp datetime);
  insert into temp values ('whatever');
  </code></pre>
  
  <p>The dates are stored as <a href="http://en.wikipedia.org/wiki/Unix_time" rel="noreferrer">Unix time</a> integers. My model classes are autogenerated by Visual Studio, so how do I tell the code generator to handle these dates correctly and not make the application throw</p>
  
  <blockquote>
    <p>String was not recognized as a valid DateTime.</p>
  </blockquote>
  
  <p>exceptions on startup?</p>