npgsql - Npgsql.EntityFrameworkCore.PostgreSQL 6.0.3-ci.20220119T195857+sha.8298c156d

PostgreSQL/Npgsql provider for Entity Framework Core.

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

Copy to clipboard

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

Copy to clipboard

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

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

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 6.0.3-ci.20220119T195857
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 6.0.3-ci.20220119T195857 --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 "6.0.3-ci.20220119T195857" -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 (>= 6.0.1)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 6.0.1)
    • Microsoft.EntityFrameworkCore.Relational (>= 6.0.1)
    • Npgsql (>= 6.0.2)
  • .NETFramework 6.0: 6.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

118 total downloads
3 downloads for version 6.0.3-ci.20220119T195857+sha.8298c156d
Download (194.9 KB)
Download symbols (71.54 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
6.0.7-ci.20220804T104551+sha.6780f7e5a 196.71 KB Thu, 04 Aug 2022 10:46:14 GMT 0
6.0.6-ci.20220801T102940+sha.c189fb395 196.69 KB Mon, 01 Aug 2022 10:30:03 GMT 0
6.0.6-ci.20220721T135303+sha.ab66f6892 196.65 KB Thu, 21 Jul 2022 13:53:23 GMT 0
6.0.6-ci.20220620T201659+sha.00a836b3a 196.67 KB Mon, 20 Jun 2022 20:17:18 GMT 0
6.0.6-ci.20220619T130312+sha.80d54b793 196.38 KB Sun, 19 Jun 2022 13:03:30 GMT 0
6.0.5-ci.20220601T070151+sha.0f05a3b34 196.38 KB Wed, 01 Jun 2022 07:02:32 GMT 0
6.0.5-ci.20220525T102607+sha.d5eed8577 196.39 KB Wed, 25 May 2022 10:26:25 GMT 0
6.0.5-ci.20220519T082115+sha.3676d3ccf 196.38 KB Thu, 19 May 2022 08:21:37 GMT 1
6.0.5-ci.20220517T102329+sha.b53c32d55 196.36 KB Tue, 17 May 2022 10:23:51 GMT 1
6.0.5-ci.20220425T134048+sha.255ae7e64 196.16 KB Mon, 25 Apr 2022 13:41:10 GMT 3
6.0.5-ci.20220419T200159+sha.0680e2b90 195.98 KB Tue, 19 Apr 2022 20:02:18 GMT 2
6.0.4-ci.20220419T192522+sha.6cb649128 195.98 KB Tue, 19 Apr 2022 19:25:40 GMT 2
6.0.4-ci.20220419T111922+sha.84e0e0327 195.98 KB Tue, 19 Apr 2022 11:19:48 GMT 2
6.0.4-ci.20220320T134316+sha.6f6507703 195.96 KB Sun, 20 Mar 2022 13:43:35 GMT 4
6.0.4-ci.20220309T135144+sha.b17647162 195.74 KB Wed, 09 Mar 2022 13:52:07 GMT 5
6.0.4-ci.20220203T142652+sha.23e0e82fa 195.38 KB Thu, 03 Feb 2022 14:27:17 GMT 5
6.0.4-ci.20220201T173830+sha.5bd20c5fa 195.24 KB Tue, 01 Feb 2022 17:38:54 GMT 4
6.0.4-ci.20220127T135955+sha.a67117500 195.22 KB Thu, 27 Jan 2022 14:00:17 GMT 4
6.0.3-ci.20220126T163101+sha.e63299bc7 195.21 KB Wed, 26 Jan 2022 16:31:25 GMT 3
6.0.3-ci.20220119T195857+sha.8298c156d 194.9 KB Wed, 19 Jan 2022 19:59:23 GMT 3
6.0.3-ci.20220114T114447+sha.b39e660be 194.9 KB Fri, 14 Jan 2022 11:45:10 GMT 4
6.0.3-ci.20220113T134137+sha.53a030caa 194.83 KB Thu, 13 Jan 2022 13:42:01 GMT 3
6.0.3-ci.20220111T201811+sha.fe0494fff 194.83 KB Tue, 11 Jan 2022 20:18:51 GMT 3
6.0.3-ci.20211230T123713+sha.1678cdacb 194.82 KB Thu, 30 Dec 2021 12:37:43 GMT 2
6.0.3-ci.20211229T222034+sha.b461f8348 194.81 KB Wed, 29 Dec 2021 22:20:54 GMT 3
6.0.3-ci.20211229T140416+sha.bfd20dee5 194.8 KB Wed, 29 Dec 2021 14:04:36 GMT 3
6.0.3-ci.20211227T103753+sha.67edc3a97 194.81 KB Mon, 27 Dec 2021 10:38:15 GMT 3
6.0.3-ci.20211222T194938+sha.b7620f3c4 194.73 KB Wed, 22 Dec 2021 19:49:58 GMT 3
6.0.2-ci.20211222T185449+sha.854d24388 194.73 KB Wed, 22 Dec 2021 18:55:09 GMT 3
6.0.2-ci.20211222T183446+sha.5675010f8 194.72 KB Wed, 22 Dec 2021 18:35:05 GMT 3
6.0.2-ci.20211222T174225+sha.376c503e4 194.72 KB Wed, 22 Dec 2021 17:42:47 GMT 3
6.0.2-ci.20211222T172150+sha.06b6e5071 194.67 KB Wed, 22 Dec 2021 17:22:12 GMT 3
6.0.2-ci.20211222T110820+sha.ef50fe29e 194.67 KB Wed, 22 Dec 2021 11:08:40 GMT 3
6.0.2-ci.20211220T104549+sha.7ff6990f9 194.67 KB Mon, 20 Dec 2021 10:46:13 GMT 3
6.0.2-ci.20211219T204622+sha.a1d317a15 194.64 KB Sun, 19 Dec 2021 20:46:42 GMT 2
6.0.2-ci.20211219T120450+sha.fc902143c 194.59 KB Sun, 19 Dec 2021 12:05:13 GMT 1
6.0.2-ci.20211219T114939+sha.d2c4adf6e 194.58 KB Sun, 19 Dec 2021 11:50:04 GMT 2
6.0.2-ci.20211217T191529+sha.f353dfb67 194.59 KB Fri, 17 Dec 2021 19:15:50 GMT 2
6.0.2-ci.20211216T124149+sha.e41ca000c 194.56 KB Thu, 16 Dec 2021 12:42:11 GMT 2
6.0.2-ci.20211215T181905+sha.d9aa628f0 194.57 KB Wed, 15 Dec 2021 18:19:27 GMT 2
6.0.2-ci.20211213T190738+sha.a926c14a0 194.21 KB Mon, 13 Dec 2021 19:08:01 GMT 2
6.0.2-ci.20211206T230049+sha.d716251d1 194.18 KB Mon, 06 Dec 2021 23:01:12 GMT 2
6.0.2-ci.20211203T143800+sha.22f475d57 194.19 KB Fri, 03 Dec 2021 14:38:20 GMT 2
6.0.1-ci.20211203T134730+sha.2d7c525cb 194.18 KB Fri, 03 Dec 2021 13:47:51 GMT 2
6.0.1-ci.20211124T104555+sha.c5a37be71 194.16 KB Wed, 24 Nov 2021 10:46:16 GMT 3
6.0.1-ci.20211117T222212+sha.06b973025 194.15 KB Wed, 17 Nov 2021 22:22:34 GMT 4
6.0.1-ci.20211112T194840+sha.d47b4dfb8 194.11 KB Fri, 12 Nov 2021 19:49:03 GMT 3
6.0.1-ci.20211111T134100+sha.791fe2923 192.73 KB Thu, 11 Nov 2021 13:41:24 GMT 3
6.0.1-ci.20211109T194043+sha.8d18e7dae 192.73 KB Tue, 09 Nov 2021 19:41:04 GMT 3
5.0.11-ci.20220120T164224+sha.088741bf5 157.56 KB Thu, 20 Jan 2022 16:42:49 GMT 2