npgsql-vnext - Npgsql 9.0.0-preview.1-ci.20240726T141743+sha.04de96873
Npgsql is the open source .NET data provider for PostgreSQL.
PM> Install-Package Npgsql -Version 9.0.0-preview.1-ci.20240726T141743 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json
> nuget.exe install Npgsql -Version 9.0.0-preview.1-ci.20240726T141743 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json
> dotnet add package Npgsql --version 9.0.0-preview.1-ci.20240726T141743 --source https://www.myget.org/F/npgsql-vnext/api/v3/index.json
<PackageReference Include="Npgsql" Version="9.0.0-preview.1-ci.20240726T141743" />
Copy to clipboard
source https://www.myget.org/F/npgsql-vnext/api/v3/index.json
nuget Npgsql ~> 9.0.0-preview.1-ci.20240726T141743
Copy to clipboard
> choco install Npgsql --version 9.0.0-preview.1-ci.20240726T141743 --source https://www.myget.org/F/npgsql-vnext/api/v2
Import-Module PowerShellGet
Register-PSRepository -Name "npgsql-vnext" -SourceLocation "https://www.myget.org/F/npgsql-vnext/api/v2"
Install-Module -Name "Npgsql" -RequiredVersion "9.0.0-preview.1-ci.20240726T141743" -Repository "npgsql-vnext" -AllowPreRelease
Copy to clipboard
Browse the sources in this package using Visual Studio or WinDbg by configuring the following symbol server URL: https://www.myget.org/F/npgsql-vnext/api/v2/symbolpackage/
Npgsql - the .NET data provider for PostgreSQL
What is Npgsql?
Npgsql is the open source .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.
For the full documentation, please visit the Npgsql website. For the Entity Framework Core provider that works with this provider, see Npgsql.EntityFrameworkCore.PostgreSQL.
Quickstart
Here's a basic code snippet to get you started:
using Npgsql;
var connString = "Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase";
var dataSourceBuilder = new NpgsqlDataSourceBuilder(connString);
var dataSource = dataSourceBuilder.Build();
var conn = await dataSource.OpenConnectionAsync();
// Insert some data
await using (var cmd = new NpgsqlCommand("INSERT INTO data (some_field) VALUES (@p)", conn))
{
cmd.Parameters.AddWithValue("p", "Hello world");
await cmd.ExecuteNonQueryAsync();
}
// Retrieve all rows
await using (var cmd = new NpgsqlCommand("SELECT some_field FROM data", conn))
await using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
Console.WriteLine(reader.GetString(0));
}
Key features
- High-performance PostgreSQL driver. Regularly figures in the top contenders on the TechEmpower Web Framework Benchmarks.
- Full support of most PostgreSQL types, including advanced ones such as arrays, enums, ranges, multiranges, composites, JSON, PostGIS and others.
- Highly-efficient bulk import/export API.
- Failover, load balancing and general multi-host support.
- Great integration with Entity Framework Core via Npgsql.EntityFrameworkCore.PostgreSQL.
For the full documentation, please visit the Npgsql website at https://www.npgsql.org.
-
.NETFramework 6.0
- Microsoft.Extensions.Logging.Abstractions (>= 8.0.0)
- System.Diagnostics.DiagnosticSource (>= 8.0.0)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Text.Json (>= 8.0.4)
-
.NETFramework 8.0
- Microsoft.Extensions.Logging.Abstractions (>= 8.0.0)
- .NETFramework 6.0: 6.0.0.0
- .NETFramework 8.0: 8.0.0.0
OwnersShay Rojansky |
AuthorsShay Rojansky, Nikita Kazmin, Brar Piening, Nino Floris, Yoh Deadfall, Austin Drenski, Emil Lenngren, Francisco Figueiredo Jr., Kenji Uno |
Project URLhttps://github.com/npgsql/npgsql |
LicenseUnknown |
Tagsnpgsql postgresql postgres ado ado.net database sql |
Info45 total downloads |
1 downloads for version 9.0.0-preview.1-ci.20240726T141743+sha.04de96873 |
Download (1.1 MB) |
Download symbols (340.59 KB) |
Found on the current feed only |