Npgsql.NetTopologySuite 9.0.2

Prefix Reserved
dotnet add package Npgsql.NetTopologySuite --version 9.0.2                
NuGet\Install-Package Npgsql.NetTopologySuite -Version 9.0.2                
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="9.0.2" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Npgsql.NetTopologySuite --version 9.0.2                
#r "nuget: Npgsql.NetTopologySuite, 9.0.2"                
#r directive can be used in F# Interactive and Polyglot Notebooks. 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=9.0.2

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

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, add a dependency on this package and create a NpgsqlDataSource.

using Npgsql;
using NetTopologySuite.Geometries;

var dataSourceBuilder = new NpgsqlDataSourceBuilder(ConnectionString);

dataSourceBuilder.UseNetTopologySuite();

var dataSource = dataSourceBuilder.Build();
var conn = await dataSource.OpenConnectionAsync();

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 Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (25)

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

Package Downloads
Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite

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

Weasel.Postgresql

Npgsql Helpers and Postgresql Schema Migration Tool, spin off of Marten

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 documentation: https://www.mars-group.org/docs/tutorial/intro

learun.database

力软ORM

GitHub repositories (5)

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

Repository Stars
dotnetcore/FreeSql
🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, DuckDB orm, TDengine orm, QuestDB 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等多种数据库的文档查询和导出功能。
shesha-io/shesha-framework
An open-source Low-Code development framework for .NET developers. Create .NET based business applications with 80% less code.
victor-wiki/DatabaseManager
A simple tool for databases : SqlServer, MySql, Oracle, Postgres and SQLite
Version Downloads Last updated
9.0.2 2,896 12/7/2024
9.0.1 19,968 11/19/2024
9.0.0 4,192 11/18/2024
8.0.6 14,961 11/18/2024
8.0.5 95,456 10/13/2024
8.0.4 66,573 9/10/2024
8.0.3 857,871 5/9/2024
8.0.2 379,639 2/10/2024
8.0.1 27,872 12/4/2023
8.0.0 351,113 11/21/2023
8.0.0-rtm 144 11/20/2023
8.0.0-rc.2 16,882 10/11/2023
8.0.0-preview.4 17,583 5/17/2023
8.0.0-preview.3 6,443 4/24/2023
8.0.0-preview.2 676 3/20/2023
8.0.0-preview.1 862 3/3/2023
7.0.9 158 11/18/2024
7.0.8 2,830 9/10/2024
7.0.7 72,912 5/9/2024
7.0.6 293,998 9/14/2023
7.0.4 470,896 4/24/2023
7.0.2 985,586 2/15/2023
7.0.1 218,976 12/17/2022
7.0.0 233,602 11/9/2022
7.0.0-rc.2 2,937 10/11/2022
7.0.0-rc.1 773 9/16/2022
7.0.0-preview.7 9,019 8/9/2022
7.0.0-preview.6 1,855 7/13/2022
7.0.0-preview.5 2,435 6/19/2022
7.0.0-preview.4 1,708 5/11/2022
7.0.0-preview.3 743 4/19/2022
7.0.0-preview.2 670 3/16/2022
7.0.0-preview.1 293 2/17/2022
6.0.13 140 11/18/2024
6.0.12 967 9/10/2024
6.0.11 44,701 5/9/2024
6.0.10 111,265 9/14/2023
6.0.9 64,393 2/15/2023
6.0.8 402,340 12/17/2022
6.0.7 719,293 9/16/2022
6.0.6 248,646 8/4/2022
6.0.5 218,872 6/19/2022
6.0.4 334,255 4/19/2022
6.0.3 738,739 1/27/2022
6.0.2 205,323 12/20/2021
6.0.1 47,145 12/3/2021
6.0.0 271,884 11/9/2021
6.0.0-rc.2 11,553 10/14/2021
6.0.0-rc.1 1,295 9/24/2021
6.0.0-preview7 1,916 8/16/2021
6.0.0-preview6 549 7/31/2021
6.0.0-preview5 1,287 7/1/2021
6.0.0-preview4 590 5/27/2021
6.0.0-preview3 8,555 4/15/2021
6.0.0-preview2 640 3/11/2021
5.0.18 1,649 5/9/2024
5.0.17 792 9/14/2023
5.0.16 1,847 2/15/2023
5.0.15 2,523 9/16/2022
5.0.14 6,625 6/19/2022
5.0.13 2,272 4/26/2022
5.0.12 5,484 2/1/2022
5.0.11 243,825 11/12/2021
5.0.10 314,987 9/15/2021
5.0.7 291,636 6/13/2021
5.0.5 192,633 5/11/2021
5.0.4 76,524 3/25/2021
5.0.3 247,157 1/26/2021
5.0.2 222,643 1/19/2021
5.0.1.1 52,465 12/12/2020
5.0.0 98,660 11/15/2020
5.0.0-preview1.1 6,326 10/13/2020
5.0.0-alpha1 452 6/17/2020
4.1.14 266 5/18/2024
4.1.13 2,385 5/9/2024
4.1.12 23,816 6/19/2022
4.1.11 1,353 4/26/2022
4.1.9 93,823 4/6/2021
4.1.8 104,408 1/21/2021
4.1.7 15,643 12/12/2020
4.1.6 30,679 11/15/2020
4.1.5 58,061 9/28/2020
4.1.4 81,230 7/19/2020
4.1.3 691,363 1/31/2020
4.1.2 59,597 11/14/2019
4.1.1 25,586 10/2/2019
4.1.0 31,226 9/26/2019
4.1.0-preview2 989 9/4/2019
4.1.0-preview1 534 8/15/2019
4.0.17 181 6/10/2024
4.0.16 146 5/18/2024
4.0.15 122 5/18/2024
4.0.14 120 5/9/2024
4.0.13 1,228 6/19/2022
4.0.11 4,302 7/19/2020
4.0.10 11,410 9/9/2019
4.0.9 10,234 8/14/2019
4.0.8 1,938 7/18/2019
4.0.7 23,632 5/21/2019
4.0.6 19,313 4/11/2019
4.0.5 20,461 3/3/2019
4.0.4.1 285,701 12/7/2018
1.0.2 65,948 7/20/2018
1.0.1 27,055 5/31/2018
1.0.0 1,980 5/30/2018
1.0.0-rc1 1,067 5/8/2018