npgsql - Npgsql.EntityFrameworkCore.PostgreSQL 7.0.4-ci.20230215T105613+sha.6bb9f42fe

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.4-ci.20230215T105613 -Source https://www.myget.org/F/npgsql/api/v3/index.json

Copy to clipboard

> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.4-ci.20230215T105613 -Source https://www.myget.org/F/npgsql/api/v3/index.json

Copy to clipboard

> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.4-ci.20230215T105613 --source https://www.myget.org/F/npgsql/api/v3/index.json

Copy to clipboard
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.4-ci.20230215T105613" />
Copy to clipboard
source https://www.myget.org/F/npgsql/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 7.0.4-ci.20230215T105613
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.4-ci.20230215T105613 --source https://www.myget.org/F/npgsql/api/v2

Copy to clipboard
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.4-ci.20230215T105613" -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

stable next patch daily builds (vnext) build gitter

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

  • .NETFramework 6.0
    • Microsoft.EntityFrameworkCore (>= 7.0.3 && < 8.0.0)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.3 && < 8.0.0)
    • Microsoft.EntityFrameworkCore.Relational (>= 7.0.3 && < 8.0.0)
    • Npgsql (>= 7.0.2)
  • .NETFramework 7.0
    • Microsoft.EntityFrameworkCore (>= 7.0.3 && < 8.0.0)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.3 && < 8.0.0)
    • Microsoft.EntityFrameworkCore.Relational (>= 7.0.3 && < 8.0.0)
    • Npgsql (>= 7.0.2)
  • .NETFramework 6.0: 6.0.0.0
  • .NETFramework 7.0: 7.0.0.0

Owners

Shay Rojansky

Authors

Shay Rojansky, Austin Drenski, Yoh Deadfall

Project URL

https://github.com/npgsql/efcore.pg

License

MIT

Tags

npgsql postgresql postgres Entity Framework Core entity-framework-core ef efcore orm sql

Info

273 total downloads
9 downloads for version 7.0.4-ci.20230215T105613+sha.6bb9f42fe
Download (535.97 KB)
Download symbols (153.58 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
9.0.3-ci.20241207T181506+sha.e5e901e32 319.48 KB Sat, 07 Dec 2024 18:15:27 GMT 0
9.0.2-ci.20241207T180802+sha.697dd7182 319.49 KB Sat, 07 Dec 2024 18:08:26 GMT 0
9.0.2-ci.20241120T194418+sha.17e2fc83c 319.48 KB Wed, 20 Nov 2024 19:44:38 GMT 0
9.0.2-ci.20241119T122358+sha.051d00cbb 319.49 KB Tue, 19 Nov 2024 12:24:20 GMT 0
9.0.1-ci.20241119T121501+sha.2e9a27fa9 319.48 KB Tue, 19 Nov 2024 12:15:24 GMT 0
9.0.1-ci.20241119T115818+sha.2e9a27fa9 319.48 KB Tue, 19 Nov 2024 11:58:39 GMT 0
9.0.1-ci.20241118T154406+sha.7aa8be018 319.47 KB Mon, 18 Nov 2024 15:44:29 GMT 0
8.0.12-ci.20241118T173708+sha.38b9ef7a1 302.16 KB Mon, 18 Nov 2024 17:37:38 GMT 0
8.0.11-ci.20241106T154257+sha.157ea2efb 302.15 KB Wed, 06 Nov 2024 15:43:27 GMT 1
8.0.11-ci.20241105T160321+sha.e38ff7bee 302.13 KB Tue, 05 Nov 2024 16:03:59 GMT 0
8.0.11-ci.20241105T125658+sha.eaafa4457 302.13 KB Tue, 05 Nov 2024 12:57:19 GMT 0
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 8
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 7
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