When trying to create a new ISession instance, NHibernate throwed the following error message:
Dialect does not support DbType.Guid Parameter name: typecode
at NHibernate.Dialect.TypeNames.Get(DbType typecode)
at NHibernate.Mapping.Table.SqlTemporaryTableCreateString(Dialect dialect, IMapping mapping)
at NHibernate.Mapping.PersistentClass.PrepareTemporaryTables(IMapping mapping, Dialect dialect)
at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
at NHibernate.Cfg.Configuration.BuildSessionFactory()
at FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory()
As you can probably guess from the title, we are using PostgreSQL and it turns out that the default used Dialect doesn’t support Guids. Luckily this was fixed a long time ago and the only thing I had to do was specify explicitly a higher Dialect version:
| private static ISessionFactory CreateSessionFactory() | |
| { | |
| return Fluently.Configure() | |
| .Database(PostgreSQLConfiguration.Standard | |
| .ConnectionString("<connection string>") | |
| .Dialect<PostgreSQL82Dialect>().ShowSql() | |
| ) | |
| .Mappings(m => | |
| m.FluentMappings.AddFromAssemblyOf<Program>()) | |
| .BuildSessionFactory(); | |
| } |