How to manage Microsoft.SqlServer.Types in Record and Migrations

Topics: Core, Writing modules
Nov 30, 2011 at 2:35 PM

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?

Dec 1, 2011 at 5:12 AM

We stay clear of anything that is not cross-DB compatible. Some people are using postgresql, mysql, oracle, etc.