Beginor.NHibernate.NpgSql

NHibernate Extension for supporting of PostgreSQL's json, jsonb and string[] field.

Usage

1. Set connection.driver_class to Beginor.NHibernate.NpgSql.NpgSqlDriver,Beginor.NHibernate.NpgSql as flow:

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
  <session-factory>
    <property name="connection.driver_class">Beginor.NHibernate.NpgSql.NpgSqlDriver,Beginor.NHibernate.NpgSql</property>
    <property name="dialect">NHibernate.Dialect.PostgreSQL82Dialect</property>
    <!-- other properties -->
  </session-factory>
</hibernate-configuration>

2. Reference the types needed to mapping file

TestEntity.hbm.xml

<?xml version="1.0" encoding="UTF-8" ?>
<hibernate-mapping
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="urn:nhibernate-mapping-2.2"
    namespace="Beginor.NHibernate.NpgSql.Test.Data"
    assembly="Beginor.NHibernate.NpgSql.Test"
    >

    <typedef name="npgJson" class="Beginor.NHibernate.NpgSql.JsonType, Beginor.NHibernate.NpgSql" />
    <typedef name="npgJsonb" class="Beginor.NHibernate.NpgSql.JsonbType, Beginor.NHibernate.NpgSql" />
    <typedef name="npgStringArray" class="Beginor.NHibernate.NpgSql.StringArrayType, Beginor.NHibernate.NpgSql" />

</hibernate-mapping>

3. Use theme in mapping file

<class name="TestEntity" table="test_table" schema="public">
    <id name="Id" column="id" type="int">
        <generator class="sequence">
            <param name="sequence">public.test_table_id_seq</param>
        </generator>
    </id>
    <property name="Name" column="name" type="string" length="32" />
    <property name="Tags" column="tags" type="npgStringArray" length="32"></property>
    <property name="JsonField" column="json_field" type="npgJson" />
    <property name="JsonbField" column="jsonb_field" type="npgJson" />
    <property name="UpdateTime" column="update_time" type="datetime" />
</class>

TestEntity is something like:

using System;

namespace Beginor.NHibernate.NpgSql.Test.Data {

    public class TestEntity {

        public virtual int Id { get; set; }

        public virtual string Name { get; set; }

        public virtual string[] Tags { get; set; }

        public virtual string JsonField { get; set; }

        public virtual string JsonbField { get; set; }

        public virtual DateTime UpdateTime { get; set; }
    }

}

Done !