title: Unit testing NHibernate w/ SQLite and DateTimeOffset mappings
body: <p>Porting over an application to use NHibernate from a different ORM.  </p>
  
  <p>I've started to put in place the ability to run our unit tests against an in memory SQLite database.  This works on the first few batches of tests, but I just hit a snag.  Our app would in the real world be talking to a SQL 2008 server, and as such, several models currently have a DateTimeOffset property.  When mapping to/from SQL 2008 in non-test applications, this all works fine.</p>
  
  <p>Is there some mechanism either in configuring the database or some other facility so that when I use a session from my SQLite test fixture that the DateTimeOffset stuff is "auto-magically" handled as the more platform agnostic DateTime?</p>