SQLITE NHibernate DateTime2

While working on a project I was using a MsSQL 2012 database for my persistence layer but wanted to use a SQLITE in memory database for my unit/integration testing.  As part of my mapping setup I used an NHibernate Version column which used DateTime2:

NHibernate Mapping Code:

	public abstract class EntityBaseMap<T> : ClassMap<T> where T : EntityBase<T>
	{
	protected EntityBaseMap()
	{
	DynamicUpdate(); // Hibernate will update the modified columns only.
	Id(x => x.Id).Column("Id"); // Numberic Id
	Map(x => x.IsDeleted);
	Map(x => x.CreatedAt);
	OptimisticLock.Version();
	// DateTime2 is not a valid SQLITE database type. To use DateTime2 with SQLITE
	// you need to extend the SQLITE Dialect and
	Version(x => x.ModifiedAt).Column("ModifiedAt").CustomType("DateTime2");
	}
	}

view raw EntityBaseMap.cs hosted with ❤ by GitHub

Unforntuently SQLITE doesn't support DateTime2. After searching around and not finding a good solution, I ended up extending SQLiteDialect class to map it to TEXT per the following link:   http://stackoverflow.com/a/16597386/2544235

SQLiteDialect Code:

	public class CustomDialect : SQLiteDialect
	{
	protected override void RegisterColumnTypes()
	{
	base.RegisterColumnTypes();
	RegisterColumnType(DbType.DateTime2, "DATETIME2");
	}
	protected override void RegisterFunctions()
	{
	base.RegisterFunctions();
	RegisterFunction("current_timestamp", new NoArgSQLFunction("TEXT", NHibernateUtil.DateTime2, true));
	}
	protected override void RegisterKeywords()
	{
	base.RegisterKeywords();
	RegisterKeyword("datetime2");
	}
	protected override void RegisterDefaultProperties()
	{
	base.RegisterDefaultProperties();
	}
	}

view raw CustomDialect.cs hosted with ❤ by GitHub