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
<PackageReference Include="Npgsql.NetTopologySuite" Version="9.0.2" />
paket add Npgsql.NetTopologySuite --version 9.0.2
#r "nuget: Npgsql.NetTopologySuite, 9.0.2"
// 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 | Versions 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. |
-
net6.0
- NetTopologySuite (>= 2.5.0)
- NetTopologySuite.IO.PostGIS (>= 2.1.0)
- Npgsql (>= 9.0.2)
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 |