Would it be possible to use the new Microsoft.SqlServer.Types that come in addition to DbType in Sql Server 2008 to manage column types like Hierarchy or Geography in Record ?
Questions to answer :
- Is it available in SqlCe?
- Can it be done in a specific module?
- Does NHibernate support that kind of column in sql request (and some associated functions like spatial ones)?
- Could Migration evolve to manage that kind of column type?