Npgsql.NetTopologySuite 7.0.1

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
.NET Standard 2.0
dotnet add package Npgsql.NetTopologySuite --version 7.0.1
NuGet\Install-Package Npgsql.NetTopologySuite -Version 7.0.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Npgsql.NetTopologySuite" Version="7.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Npgsql.NetTopologySuite --version 7.0.1
#r "nuget: Npgsql.NetTopologySuite, 7.0.1"
#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 Npgsql.NetTopologySuite as a Cake Addin
#addin nuget:?package=Npgsql.NetTopologySuite&version=7.0.1

// Install Npgsql.NetTopologySuite as a Cake Tool
#tool nuget:?package=Npgsql.NetTopologySuite&version=7.0.1

Npgsql is the open source .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.

This package is an Npgsql plugin which allows you to interact with spatial data provided by the PostgreSQL PostGIS extension; PostGIS is a mature, standard extension considered to provide top-of-the-line database spatial features. On the .NET side, the plugin adds support for the types from the NetTopologySuite library, allowing you to read and write them directly to PostgreSQL.

To use the NetTopologySuite plugin, simply add a dependency on this package and set it up at program startup:

NpgsqlConnection.GlobalTypeMapper.UseNetTopologySuite();

Once this is done, you can simply use NetTopologySuite types when interacting with PostgreSQL:

var point = new Point(new Coordinate(1d, 1d));
conn.ExecuteNonQuery("CREATE TEMP TABLE data (geom GEOMETRY)");
using (var cmd = new NpgsqlCommand("INSERT INTO data (geom) VALUES (@p)", conn))
{
    cmd.Parameters.AddWithValue("@p", point);
    cmd.ExecuteNonQuery();
}

using (var cmd = new NpgsqlCommand("SELECT geom FROM data", conn))
using (var reader = cmd.ExecuteReader())
{
    reader.Read();
    Assert.That(reader[0], Is.EqualTo(point));
}

For more information, visit the NetTopologySuite plugin documentation page.

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48 net481
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (17)

Showing the top 5 NuGet packages that depend on Npgsql.NetTopologySuite:

Package Downloads
Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

NetTopologySuite PostGIS spatial support plugin for PostgreSQL/Npgsql Entity Framework Core provider.

FreeSql.Provider.PostgreSQL

FreeSql 数据库实现,基于 PostgreSQL 9.5

Mars.Core

The runtime core provides step-based execution for multi-agent simulations in distributed environments as well as polyglot result output with different output types such as (MongoDB, PostgreSQL, Redis, CSV, GeoJson Socket, ...). For furher details please use the handbook: https://mars-group.org/wp-content/uploads/2018/09/mars-modelling-handbook.pdf

FSharp.Data.Npgsql

F# type provider to support statically typed access to input parameters and result sets of sql statements in an idiomatic F# way. Data modifications via statically typed tables.

NHibernate.Spatial.PostGis

NHibernate.Spatial is a library of spatial extensions for NHibernate, and allows you to connect NHibernate to a spatially enabled database and manipulate geometries in HQL or in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on Npgsql.NetTopologySuite:

Repository Stars
dotnetcore/FreeSql
🦄 .NET orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 国产 orm, Clickhouse orm, MsAccess orm.
npgsql/efcore.pg
Entity Framework Core provider for PostgreSQL
TeslaFly01/SmartSqlT
🔥🔥🔥 SmartSQL 是一款方便、快捷的数据库文档查询、导出工具!该工具从最初支持CHM文档格式开始,通过不断地探索开发、集思广益和不断改进,又陆续支持Word、Excel、PDF、Html、Xml、Json、MarkDown等文档格式的导出。同时支持SqlServer、MySql、PostgreSQL、SQLite等多种数据库的文档查询和导出功能。
Version Downloads Last updated
7.0.1 22,396 12/17/2022
7.0.0 25,481 11/9/2022
7.0.0-rc.2 2,567 10/11/2022
7.0.0-rc.1 520 9/16/2022
7.0.0-preview.7 4,931 8/9/2022
7.0.0-preview.6 1,669 7/13/2022
7.0.0-preview.5 1,217 6/19/2022
7.0.0-preview.4 855 5/11/2022
7.0.0-preview.3 658 4/19/2022
7.0.0-preview.2 550 3/16/2022
7.0.0-preview.1 159 2/17/2022
6.0.8 7,205 12/17/2022
6.0.7 264,588 9/16/2022
6.0.6 131,982 8/4/2022
6.0.5 116,161 6/19/2022
6.0.4 191,454 4/19/2022
6.0.3 509,075 1/27/2022
6.0.2 88,761 12/20/2021
6.0.1 31,379 12/3/2021
6.0.0 58,163 11/9/2021
6.0.0-rc.2 11,266 10/14/2021
6.0.0-rc.1 1,197 9/24/2021
6.0.0-preview7 1,753 8/16/2021
6.0.0-preview6 394 7/31/2021
6.0.0-preview5 822 7/1/2021
6.0.0-preview4 427 5/27/2021
6.0.0-preview3 7,945 4/15/2021
6.0.0-preview2 412 3/11/2021
5.0.15 482 9/16/2022
5.0.14 2,243 6/19/2022
5.0.13 1,176 4/26/2022
5.0.12 4,235 2/1/2022
5.0.11 69,033 11/12/2021
5.0.10 197,148 9/15/2021
5.0.7 230,599 6/13/2021
5.0.5 167,202 5/11/2021
5.0.4 63,922 3/25/2021
5.0.3 175,143 1/26/2021
5.0.2 182,663 1/19/2021
5.0.1.1 49,560 12/12/2020
5.0.0 75,788 11/15/2020
5.0.0-preview1.1 6,173 10/13/2020
5.0.0-alpha1 350 6/17/2020
4.1.12 699 6/19/2022
4.1.11 1,053 4/26/2022
4.1.9 37,969 4/6/2021
4.1.8 79,186 1/21/2021
4.1.7 11,973 12/12/2020
4.1.6 22,963 11/15/2020
4.1.5 41,875 9/28/2020
4.1.4 62,701 7/19/2020
4.1.3 605,072 1/31/2020
4.1.2 51,432 11/14/2019
4.1.1 22,270 10/2/2019
4.1.0 7,094 9/26/2019
4.1.0-preview2 837 9/4/2019
4.1.0-preview1 436 8/15/2019
4.0.13 614 6/19/2022
4.0.11 2,284 7/19/2020
4.0.10 10,046 9/9/2019
4.0.9 7,131 8/14/2019
4.0.8 1,734 7/18/2019
4.0.7 22,514 5/21/2019
4.0.6 15,438 4/11/2019
4.0.5 16,771 3/3/2019
4.0.4.1 243,271 12/7/2018
1.0.2 61,934 7/20/2018
1.0.1 21,840 5/31/2018
1.0.0 1,031 5/30/2018
1.0.0-rc1 894 5/8/2018