Fujitsu Enterprise Postgres .NET Data Provider now comes packaged with 4 Type Plugins that provide additional support for more data type mappings (eg date time support via the Npgsql.NodaTime). The plugins modify how Npgsql maps the PostgreSQL values to CLR types.

The type plugins are available for installation as a local NuGet packages. There are 4 pacakages available for installation. "<x>" indicates the product version.

• Npgsql.NodaTime.<x>.0.0.nupkg

• Npgsql.Json.NET.<x>.0.0.nupkg

• Npgsql.NetTopologySuite.<x>.0.0.nupkg: Spatial type(*1)

• Npgsql.GeoJSON.<x>.0.0.nupkg: Spatial type(*1)

*1: Please note that the Spatial Type plugins require the PostGIS extension installed on the server.

Also, Refre to "Type Plugins" and "Additional Notes on each Type Plugin" on the each type plugins.

To install any of the plugins please follow the procedure below:

Location of NuGet package

The Plugin NuGet package are stored in the following location. "<x>" indicates the product version.

• Linux

  fujitsuEnterprisePostgresClientInstallDir/DOTNET/Npgsql.*.<x>.0.0.nupkg

• Windows(R)

  fujitsuEnterprisePostgresClientInstallDir\DOTNET\Npgsql.*.<x>.0.0.nupkg

Add a local package source

Add a NuGet local package source if one does not exist.

• Linux

  Add the above Nuget package location as a local package source.

  dotnet nuget add source fujitsuEnterprisePostgresClientInstallDir/DOTNET -n sourceName

• Windows(R)

  1. Start Visual Studio, click [Tools] >> [Options] >> [NuGet Package Manager], and then select [Package Sources].

  2. Click [+] in the upper-right corner, and then set [Name] to "Local Package Source".

  3. Click […] and navigate to the folder above. Select this folder, and then click [OK].

Install the NuGet package

Install the NuGet package from the local package source.

• Linux

  Add a package reference to the project file (Example: Npgsql.NodaTime).

  dotnet add projectFilePath package Npgsql.NodaTime

• Windows(R)

  1. Start Visual Studio, click [Tools] >> [NuGet Package Manager] >> [Manage NuGet Packages for Solution].

  2. In the upper-right corner, select "Local Package Source" from [Package Source].

  3. Once the local package source is set, all available NuGet packages in this local location will be displayed. Select the plugin to be installed (eg "Npgsql.NodaTime", and then select the projects for which this package is to be installed.

  4. Click [Install].