NHibernate: Adding DbTypes For Postgres

Question

I am trying to register new DbTypes for custom user types, and it is only allowing me to use the asp.net DbTypes to associate custom user types that I have created.. for instance:

    /// <summary>
/// An SQL dialect for PostgreSQL 8.2 and above.
/// </summary>
/// <remarks>
/// PostgreSQL 8.2 supports <c>DROP TABLE IF EXISTS tablename</c>
/// and <c>DROP SEQUENCE IF EXISTS sequencename</c> syntax.
/// See <see cref="PostgreSQLDialect" /> for more information.
/// </remarks>
public class PostgreSQL82Dialect : PostgreSQL81Dialect
{
    public PostgreSQL82Dialect()
    {
        RegisterColumnType(DbType.Guid, "uuid");
        RegisterColumnType(DbType.Object, "uuid[]");
        RegisterColumnType(DbType.Object, "integer[]");
        RegisterColumnType(DbType.Binary, "jsonb");
    }

    public override bool SupportsIfExistsBeforeTableName
    {
        get { return true; }
    }

    public override string GetDropSequenceString(string sequenceName)
    {
        return string.Concat("drop sequence if exists ", sequenceName);
    }
}

I added uuid[], integer[] and jsonb. The only problem is when you try to do a schema update it always gets the last column type registered for any given dbtype. The problem with that is, there is no .net data type specified for arrays or blobs... so I have to use object for them. In this case, any custom user type that has a dbtype of object will always be an integer array in the database when I call schema update like so:

   var update = new SchemaUpdate(configuration);
   update.Execute(true, true);

Is there another way to let NHibernate know how to map these columns to the database?

Thanks in advance.

Oskar Berggren · Accepted Answer · 2014-10-15 18:38:05Z

2

You need to specify the sql-type in the mapping:

<property name="Foo" type="String">
    <column name="foo" length="64" not-null="true" sql-type="text"/>
</property>

answered Oct 15, 2014 at 18:38

Oskar Berggren

5,6661 gold badge21 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NHibernate: Adding DbTypes For Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related