nhibernate.postgresql.json 1.1.2

Install-Package nhibernate.postgresql.json -Version 1.1.2
dotnet add package nhibernate.postgresql.json --version 1.1.2
<PackageReference Include="nhibernate.postgresql.json" Version="1.1.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add nhibernate.postgresql.json --version 1.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: nhibernate.postgresql.json, 1.1.2"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install nhibernate.postgresql.json as a Cake Addin
#addin nuget:?package=nhibernate.postgresql.json&version=1.1.2

// Install nhibernate.postgresql.json as a Cake Tool
#tool nuget:?package=nhibernate.postgresql.json&version=1.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Build status


NHibernate custom type to handle PostgreSQL JSON and JSONB column types.

As of June/2019 this repository is being actively maintained.


This library depends on the following NuGet packages:

These will be installed as dependencies along with this page.

To install this download package nhibernate.postgresql.json or run:

Install-Package nhibernate.postgresql.json


This library has been tested with .NET Core 2.1 and NHibernate 5.x.


All this package does is offer an NHibernate custom type that you can use to handle json/jsonb PostgreSql data types. It relies on the configuration provided by NpgSql.Json.Net.

The way it works is by telling the extension which .NET types you want it to handle for you. This is done in the Startup class:

NpgsqlConnection.GlobalTypeMapper.UseJsonNet(new[] { typeof(AnotherType) });

It is important to note that you must specify each of the types that you want the library to handle for you and not their parents.


After the configuration is complete, you can just use it in your mapping as a custom type:

Map(x => x.PropertyWithMyType).CustomSqlType("jsonb").CustomType<JsonType<AnotherType>>().Column("db_column");

It also works with native CLR types such as Dictionary<string,string> which is perfect to store unstructured data. In my particular case, I use it to store raw data from web requests along with parsed data.

Map(x => x.Raw).CustomSqlType("jsonb").CustomType<JsonType<Dictionary<string,string>>>().Column("raw");


A more complete sample can be found below:


public class Startup
        public Startup(IConfiguration configuration)
            Configuration = configuration;

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)

            NpgsqlConnection.GlobalTypeMapper.UseJsonNet(new[] { typeof(MyType) });

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IHostingEnvironment env)
            if (env.IsDevelopment())



public class AnotherType
	public AnotherType() {}
	public virtual string AnotherProperty {get;set;}

public class MyType
	public MyType() {}

	public virtual string Name { get; set; }
	public virtual int Age { get; set; }
	public virtual AnotherType Other { get; set; }	

public class MyTypeMap : ClassMap<AnotherType>

	public MyType()

		Map(x => x.Name).Column("name");
		Map(x => x.Age).Column("age");
		Map(x => x.Other).CustomSqlType("jsonb").CustomType<JsonType<Transaction>>().Column("other").Not.Nullable();

How to contribute / I want to help

If you are interested in helping out there are a few things we could use:

  • Add tests to the project to make sure that this behaves as it should (so far I have been using it in a production app, but my use case is very simple and not comprehensive)
  • Add more examples

If you feel like helping, just send a PR 😃

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.1.2 3,154 7/26/2019
1.1.1 346 5/27/2019
1.1.0 339 5/17/2019
1.0.21 338 5/27/2019
1.0.1 564 12/26/2018
1.0.0 663 12/26/2018