npgsql - Npgsql.EntityFrameworkCore.PostgreSQL 7.0.1-ci.20221109T210536+sha.123beea2c
PostgreSQL/Npgsql provider for Entity Framework Core.
PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.1-ci.20221109T210536 -Source https://www.myget.org/F/npgsql/api/v3/index.json
> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.1-ci.20221109T210536 -Source https://www.myget.org/F/npgsql/api/v3/index.json
> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.1-ci.20221109T210536 --source https://www.myget.org/F/npgsql/api/v3/index.json
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.1-ci.20221109T210536" />
Copy to clipboard
source https://www.myget.org/F/npgsql/api/v3/index.json
nuget Npgsql.EntityFrameworkCore.PostgreSQL ~> 7.0.1-ci.20221109T210536
Copy to clipboard
> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.1-ci.20221109T210536 --source https://www.myget.org/F/npgsql/api/v2
Import-Module PowerShellGet
Register-PSRepository -Name "npgsql" -SourceLocation "https://www.myget.org/F/npgsql/api/v2"
Install-Module -Name "Npgsql.EntityFrameworkCore.PostgreSQL" -RequiredVersion "7.0.1-ci.20221109T210536" -Repository "npgsql" -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/api/v2/symbolpackage/
Npgsql Entity Framework Core provider for PostgreSQL
Npgsql.EntityFrameworkCore.PostgreSQL is the open source EF Core provider for PostgreSQL. It allows you to interact with PostgreSQL via the most widely-used .NET O/RM from Microsoft, and use familiar LINQ syntax to express queries. It's built on top of Npgsql.
The provider looks and feels just like any other Entity Framework Core provider. Here's a quick sample to get you started:
await using var ctx = new BlogContext();
await ctx.Database.EnsureDeletedAsync();
await ctx.Database.EnsureCreatedAsync();
// Insert a Blog
ctx.Blogs.Add(new() { Name = "FooBlog" });
await ctx.SaveChangesAsync();
// Query all blogs who's name starts with F
var fBlogs = await ctx.Blogs.Where(b => b.Name.StartsWith("F")).ToListAsync();
public class BlogContext : DbContext
{
public DbSet<Blog> Blogs { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.UseNpgsql(@"Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase");
}
public class Blog
{
public int Id { get; set; }
public string Name { get; set; }
}
Aside from providing general EF Core support for PostgreSQL, the provider also exposes some PostgreSQL-specific capabilities, allowing you to query JSON, array or range columns, as well as many other advanced features. For more information, see the the Npgsql site. For information about EF Core in general, see the EF Core website.
Related packages
- Spatial plugin to work with PostgreSQL PostGIS: Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite
- NodaTime plugin to use better date/time types with PostgreSQL: Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime
- The underlying Npgsql ADO.NET provider is Npgsql.
-
.NETFramework 6.0
- Microsoft.EntityFrameworkCore (>= 7.0.0 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.0 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.0 && < 8.0.0)
- Npgsql (>= 7.0.0)
-
.NETFramework 7.0
- Microsoft.EntityFrameworkCore (>= 7.0.0 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.0 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.0 && < 8.0.0)
- Npgsql (>= 7.0.0)
- .NETFramework 6.0: 6.0.0.0
- .NETFramework 7.0: 7.0.0.0
OwnersShay Rojansky |
AuthorsShay Rojansky, Austin Drenski, Yoh Deadfall |
Project URLhttps://github.com/npgsql/efcore.pg |
LicenseMIT |
Tagsnpgsql postgresql postgres Entity Framework Core entity-framework-core ef efcore orm sql |
Info366 total downloads |
10 downloads for version 7.0.1-ci.20221109T210536+sha.123beea2c |
Download (534.3 KB) |
Download symbols (153.47 KB) |
Found on the current feed only |
Package history
Version | Size | Last updated | Downloads | Mirrored? | |||
---|---|---|---|---|---|---|---|
8.0.11-ci.20241031T151546+sha.57167f600 | 301.84 KB | Thu, 31 Oct 2024 15:16:06 GMT | 1 | ||||
8.0.11-ci.20241031T112840+sha.8a2dc0c3c | 301.77 KB | Thu, 31 Oct 2024 11:29:12 GMT | 0 | ||||
8.0.11-ci.20241029T164005+sha.52e427f62 | 301.75 KB | Tue, 29 Oct 2024 16:40:27 GMT | 0 | ||||
8.0.11-ci.20241017T183438+sha.15ce73ebc | 301.72 KB | Thu, 17 Oct 2024 18:35:07 GMT | 0 | ||||
8.0.8-ci.20240926T223439+sha.55dd99eca | 301.7 KB | Thu, 26 Sep 2024 22:35:07 GMT | 0 | ||||
8.0.5-ci.20240628T141536+sha.aec0d1f72 | 301.7 KB | Fri, 28 Jun 2024 14:16:05 GMT | 5 | ||||
8.0.5-ci.20240623T224824+sha.8a4c25b3a | 301.58 KB | Sun, 23 Jun 2024 22:48:45 GMT | 5 | ||||
8.0.5-ci.20240608T214859+sha.1292512a4 | 301.38 KB | Sat, 08 Jun 2024 21:49:21 GMT | 4 | ||||
8.0.5-ci.20240511T161926+sha.a2ce3ee08 | 301.44 KB | Sat, 11 May 2024 16:19:51 GMT | 4 | ||||
8.0.4-ci.20240511T154954+sha.51faf6e9c | 301.44 KB | Sat, 11 May 2024 15:50:21 GMT | 3 | ||||
8.0.3-ci.20240225T001127+sha.f280bb70e | 301.4 KB | Sun, 25 Feb 2024 00:11:56 GMT | 5 | ||||
8.0.3-ci.20240217T202149+sha.468c8be1f | 301.47 KB | Sat, 17 Feb 2024 20:22:15 GMT | 7 | ||||
8.0.1-ci.20240105T091620+sha.bbcdde68d | 301.5 KB | Fri, 05 Jan 2024 09:16:51 GMT | 10 | ||||
8.0.1-ci.20231223T160849+sha.c698389be | 301.48 KB | Sat, 23 Dec 2023 16:09:13 GMT | 5 | ||||
8.0.1-ci.20231219T144823+sha.f958e9a34 | 301.23 KB | Tue, 19 Dec 2023 14:48:48 GMT | 6 | ||||
8.0.1-ci.20231218T120307+sha.baaf41f4b | 301.23 KB | Mon, 18 Dec 2023 12:03:35 GMT | 7 | ||||
8.0.1-ci.20231218T103437+sha.557e16689 | 301.13 KB | Mon, 18 Dec 2023 10:35:02 GMT | 8 | ||||
8.0.1-ci.20231217T054650+sha.07f00f88b | 300.43 KB | Sun, 17 Dec 2023 05:47:19 GMT | 7 | ||||
8.0.1-ci.20231217T053909+sha.b7d1ff4b2 | 300.42 KB | Sun, 17 Dec 2023 05:39:40 GMT | 6 | ||||
8.0.1-ci.20231211T103621+sha.60a157326 | 300.45 KB | Mon, 11 Dec 2023 10:36:46 GMT | 6 | ||||
8.0.1-ci.20231128T122126+sha.33f11d2f9 | 300.13 KB | Tue, 28 Nov 2023 12:21:58 GMT | 5 | ||||
8.0.1-ci.20231121T011540+sha.1780f62cf | 300.07 KB | Tue, 21 Nov 2023 01:16:11 GMT | 6 | ||||
7.0.12-ci.20231219T144220+sha.3fb24ff0e | 535.64 KB | Tue, 19 Dec 2023 14:42:54 GMT | 5 | ||||
7.0.12-ci.20230915T130042+sha.67fa94d9d | 535.55 KB | Fri, 15 Sep 2023 13:01:24 GMT | 8 | ||||
7.0.6-ci.20230605T100208+sha.be2d386d3 | 535.52 KB | Mon, 05 Jun 2023 10:02:53 GMT | 10 | ||||
7.0.6-ci.20230425T151454+sha.0770cc8a8 | 536.66 KB | Tue, 25 Apr 2023 15:15:37 GMT | 10 | ||||
7.0.4-ci.20230307T165950+sha.310aee7be | 536.24 KB | Tue, 07 Mar 2023 17:01:33 GMT | 10 | ||||
7.0.4-ci.20230303T224507+sha.f4e7769d4 | 536.21 KB | Fri, 03 Mar 2023 22:45:44 GMT | 12 | ||||
7.0.4-ci.20230302T152251+sha.3177b0018 | 536.23 KB | Thu, 02 Mar 2023 15:25:04 GMT | 10 | ||||
7.0.4-ci.20230221T131301+sha.72d78192f | 536.22 KB | Tue, 21 Feb 2023 13:13:37 GMT | 11 | ||||
7.0.4-ci.20230220T232114+sha.f265552c5 | 536.53 KB | Mon, 20 Feb 2023 23:21:50 GMT | 11 | ||||
7.0.4-ci.20230215T105613+sha.6bb9f42fe | 535.97 KB | Wed, 15 Feb 2023 10:56:47 GMT | 9 | ||||
7.0.2-ci.20230129T151307+sha.dbb82d759 | 535.97 KB | Sun, 29 Jan 2023 15:13:42 GMT | 12 | ||||
7.0.2-ci.20230127T102001+sha.f711091c4 | 534.77 KB | Fri, 27 Jan 2023 10:20:30 GMT | 10 | ||||
7.0.2-ci.20221217T161324+sha.72cc72b4e | 534.7 KB | Sat, 17 Dec 2022 16:13:57 GMT | 13 | ||||
7.0.1-ci.20221201T124005+sha.09bc34fd0 | 534.69 KB | Thu, 01 Dec 2022 12:41:07 GMT | 11 | ||||
7.0.1-ci.20221125T205720+sha.9f03e31a5 | 534.54 KB | Fri, 25 Nov 2022 20:57:49 GMT | 9 | ||||
7.0.1-ci.20221115T115357+sha.6f7e11ea4 | 534.56 KB | Tue, 15 Nov 2022 11:54:35 GMT | 9 | ||||
7.0.1-ci.20221109T210536+sha.123beea2c | 534.3 KB | Wed, 09 Nov 2022 21:06:02 GMT | 10 | ||||
6.0.23-ci.20231219T143922+sha.f8a72da60 | 237.82 KB | Tue, 19 Dec 2023 14:39:37 GMT | 5 | ||||
6.0.23-ci.20230915T124554+sha.fa8c94cea | 237.8 KB | Fri, 15 Sep 2023 12:46:15 GMT | 9 | ||||
6.0.9-ci.20230605T102621+sha.91ee83439 | 237.79 KB | Mon, 05 Jun 2023 10:26:40 GMT | 8 | ||||
6.0.9-ci.20230315T172403+sha.e5ade7f06 | 237.79 KB | Wed, 15 Mar 2023 17:24:30 GMT | 8 | ||||
6.0.9-ci.20230314T195614+sha.6feb9b710 | 237.57 KB | Tue, 14 Mar 2023 19:56:34 GMT | 10 | ||||
6.0.9-ci.20221217T164248+sha.a441c4f2d | 237.54 KB | Sat, 17 Dec 2022 16:43:11 GMT | 8 | ||||
6.0.8-ci.20221201T123120+sha.f3e50d564 | 237.54 KB | Thu, 01 Dec 2022 12:31:51 GMT | 7 | ||||
6.0.8-ci.20221015T054217+sha.ffef35f8e | 237.3 KB | Sat, 15 Oct 2022 05:42:35 GMT | 12 | ||||
6.0.8-ci.20220924T182938+sha.dbe3d7a2a | 237.21 KB | Sat, 24 Sep 2022 18:29:55 GMT | 10 | ||||
6.0.8-ci.20220920T001012+sha.f87894584 | 237.21 KB | Tue, 20 Sep 2022 00:10:34 GMT | 9 | ||||
6.0.8-ci.20220916T220458+sha.e839639ef | 237.19 KB | Fri, 16 Sep 2022 22:05:21 GMT | 10 |