title: Would an ORM have any way of determining that a SQLite column contains date-times or booleans?
body: <p>I've been thinking about using SQLite for my next project, but I'm concerned that it seems to lack proper <code>datetime</code> and <code>bit</code> data types.</p>
  
  <p>If I use DbLinq (or some other ORM) to generate C# classes, will the data types of the properties be "dumbed down"? Will date-time data be placed in properties of type <code>string</code> or <code>double</code>? Will boolean data be placed in properties of type <code>int</code>?</p>
  
  <p>If yes, what are the implications? I'm envisioning a scenario where I need to write a whole second layer of classes with more specific data types and do a bunch of transformations and casts, but maybe it's not as bad as I fear. If you have any experience with this or a similar scenario, how did you handle it?</p>