Hi David, It doesn't look like the CE dialect ever got that type registered. You can sub-class the dialect and call RegisterColumnType to extend the existing dialect.
Patches are also welcome if you wish to raise a JIRA ... you can investigate the tests that Dario committed in rev 4011 as a guide. From: Dario Quintana Sent: Tuesday, September 14, 2010 11:15 AM To: [email protected] Subject: Re: [nhibernate-development] DateTimeOffset broken with SQL CE? Hi, IIRC DateTimeOffSet is available to use with SQL 2008 dialect On Mon, Sep 13, 2010 at 12:22 AM, David Pfeffer <[email protected]> wrote: Hello, SQL CE has supported since version 3.5 SP1 (SP2 is current) time offsets. The DateTime type supports both offset-less times as well as times with offsets. However, the mapping seems to be all weird. When I use a DateTime to map to the DB, everything is fine, but when I use a DateTimeOffset, I get an error -- {No mapping exists from DbType DateTimeOffset to a known SqlDbType.} -- Dario Quintana
