npgsql-vnext - Npgsql.EntityFrameworkCore.PostgreSQL 9.0.0-preview.1-ci.20240211T200852+sha.ba3431737

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 9.0.0-preview.1-ci.20240211T200852 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 9.0.0-preview.1-ci.20240211T200852 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.0-preview.1-ci.20240211T200852 --source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="9.0.0-preview.1-ci.20240211T200852" />
Copy to clipboard
source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 9.0.0-preview.1-ci.20240211T200852
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.0-preview.1-ci.20240211T200852 --source https://www.myget.org/F/npgsql-vnext/api/v2

Copy to clipboard
Import-Module PowerShellGet
Register-PSRepository -Name "npgsql-vnext" -SourceLocation "https://www.myget.org/F/npgsql-vnext/api/v2"
Install-Module -Name "Npgsql.EntityFrameworkCore.PostgreSQL" -RequiredVersion "9.0.0-preview.1-ci.20240211T200852" -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 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 8.0
    • Microsoft.EntityFrameworkCore (>= 9.0.0-preview.1.24081.2)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 9.0.0-preview.1.24081.2)
    • Microsoft.EntityFrameworkCore.Relational (>= 9.0.0-preview.1.24081.2)
    • Npgsql (>= 8.0.2)
  • .NETFramework 8.0: 8.0.0.0

Owners

Shay Rojansky

Authors

Shay Rojansky, Austin Drenski, Yoh Deadfall

Project URL

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

License

Unknown

Tags

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

Info

100 total downloads
4 downloads for version 9.0.0-preview.1-ci.20240211T200852+sha.ba3431737
Download (303.97 KB)
Download symbols (86.74 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
10.0.0-ci.20241120T172630+sha.c6fb5e21e 319.47 KB Wed, 20 Nov 2024 17:26:51 GMT 0
10.0.0-ci.20241119T113735+sha.773a330bf 319.47 KB Tue, 19 Nov 2024 11:37:57 GMT 0
10.0.0-ci.20241118T154814+sha.03f004daf 319.46 KB Mon, 18 Nov 2024 15:48:34 GMT 0
9.0.0-rc.2-ci.20241114T213942+sha.dd8e6302f 319.5 KB Thu, 14 Nov 2024 21:40:04 GMT 0
9.0.0-rc.2-ci.20241114T212006+sha.dd8e6302f 319.49 KB Thu, 14 Nov 2024 21:20:30 GMT 0
9.0.0-rc.2-ci.20241114T190152+sha.dd8e6302f 319.49 KB Thu, 14 Nov 2024 19:02:15 GMT 0
9.0.0-rc.2-ci.20241114T163442+sha.a4d67a11c 319.48 KB Thu, 14 Nov 2024 16:35:01 GMT 0
9.0.0-rc.2-ci.20241114T140713+sha.74d8a51ea 319.12 KB Thu, 14 Nov 2024 14:07:35 GMT 0
9.0.0-rc.2-ci.20241114T135851+sha.74d8a51ea 319.12 KB Thu, 14 Nov 2024 13:59:14 GMT 0
9.0.0-rc.2-ci.20241106T153535+sha.b875f5d1c 319.13 KB Wed, 06 Nov 2024 15:35:59 GMT 0
9.0.0-rc.2-ci.20241105T155516+sha.eca01842f 319.13 KB Tue, 05 Nov 2024 15:55:43 GMT 0
9.0.0-rc.2-ci.20241105T124753+sha.ff8513a35 321.65 KB Tue, 05 Nov 2024 12:48:16 GMT 0
9.0.0-rc.2-ci.20241029T215709+sha.e4375aada 321.46 KB Tue, 29 Oct 2024 21:57:30 GMT 0
9.0.0-rc.2-ci.20241029T163141+sha.45c822781 321.55 KB Tue, 29 Oct 2024 16:32:01 GMT 0
9.0.0-rc.2-ci.20241028T213132+sha.72cb52e7f 321.54 KB Mon, 28 Oct 2024 21:31:56 GMT 0
9.0.0-rc.2-ci.20241028T100256+sha.342c5606a 321.42 KB Mon, 28 Oct 2024 10:03:18 GMT 0
9.0.0-rc.2-ci.20241028T075218+sha.c484080ba 321.38 KB Mon, 28 Oct 2024 07:52:38 GMT 0
9.0.0-rc.2-ci.20240930T080442+sha.303ffc3bd 323.07 KB Mon, 30 Sep 2024 08:05:06 GMT 3
9.0.0-rc.2-ci.20240927T174242+sha.58608e88d 323.07 KB Fri, 27 Sep 2024 17:43:06 GMT 1
9.0.0-rc.2-ci.20240923T214327+sha.922c0896a 323.03 KB Mon, 23 Sep 2024 21:43:51 GMT 1
9.0.0-rc.2-ci.20240923T072853+sha.87a1a7e3f 322.29 KB Mon, 23 Sep 2024 07:29:16 GMT 1
9.0.0-rc.2-ci.20240922T193818+sha.79608d6ab 322.06 KB Sun, 22 Sep 2024 19:38:42 GMT 1
9.0.0-rc.2-ci.20240922T190826+sha.79608d6ab 322.05 KB Sun, 22 Sep 2024 19:08:51 GMT 1
9.0.0-rc.2-ci.20240914T074209+sha.f7d79101d 321.07 KB Sat, 14 Sep 2024 07:42:33 GMT 2
9.0.0-rc.2-ci.20240913T180216+sha.b818e8297 320.45 KB Fri, 13 Sep 2024 18:02:39 GMT 1
9.0.0-rc.1-ci.20240915T105946+sha.318c46ce5 320.22 KB Sun, 15 Sep 2024 11:00:11 GMT 1
9.0.0-rc.1-ci.20240915T104507+sha.318c46ce5 320.23 KB Sun, 15 Sep 2024 10:45:31 GMT 1
9.0.0-rc.1-ci.20240915T103041+sha.318c46ce5 320.21 KB Sun, 15 Sep 2024 10:31:04 GMT 2
9.0.0-rc.1-ci.20240902T175811+sha.e31994185 320.45 KB Mon, 02 Sep 2024 17:58:35 GMT 21
9.0.0-rc.1-ci.20240901T202335+sha.318c46ce5 320.22 KB Sun, 01 Sep 2024 20:23:56 GMT 1
9.0.0-preview.7-ci.20240901T185411+sha.f3fb1a67e 320.24 KB Sun, 01 Sep 2024 18:54:35 GMT 1
9.0.0-preview.4-ci.20240901T170916+sha.36295e9f6 318.23 KB Sun, 01 Sep 2024 17:09:35 GMT 1
9.0.0-preview.4-ci.20240901T081056+sha.b91ef352f 318.17 KB Sun, 01 Sep 2024 08:11:15 GMT 1
9.0.0-preview.4-ci.20240628T131202+sha.dba77fd16 311.63 KB Fri, 28 Jun 2024 13:12:24 GMT 5
9.0.0-preview.4-ci.20240623T223307+sha.933bc8df4 311.59 KB Sun, 23 Jun 2024 22:33:27 GMT 2
9.0.0-preview.4-ci.20240608T214305+sha.3b71c73c2 311.42 KB Sat, 08 Jun 2024 21:43:23 GMT 2
9.0.0-preview.4-ci.20240518T175510+sha.6b3ca689d 311.4 KB Sat, 18 May 2024 17:55:31 GMT 3
9.0.0-preview.4-ci.20240516T124658+sha.d5de63149 306.89 KB Thu, 16 May 2024 12:47:17 GMT 3
9.0.0-preview.4-ci.20240511T083656+sha.f69fc1d8e 306.9 KB Sat, 11 May 2024 08:37:14 GMT 3
9.0.0-preview.3-ci.20240412T143842+sha.f38a96cee 306.89 KB Fri, 12 Apr 2024 14:39:02 GMT 3
9.0.0-preview.3-ci.20240404T143221+sha.17fa8de6d 305.38 KB Thu, 04 Apr 2024 14:32:52 GMT 4
9.0.0-preview.3-ci.20240403T110140+sha.ac91e9a0c 305.93 KB Wed, 03 Apr 2024 11:02:07 GMT 3
9.0.0-preview.3-ci.20240401T091105+sha.dcef41511 305.69 KB Mon, 01 Apr 2024 09:12:05 GMT 3
9.0.0-preview.3-ci.20240322T155220+sha.7f6bdbe94 305.72 KB Fri, 22 Mar 2024 15:52:46 GMT 4
9.0.0-preview.1-ci.20240320T210055+sha.533b9d31a 305.7 KB Wed, 20 Mar 2024 21:01:20 GMT 3
9.0.0-preview.1-ci.20240305T092832+sha.08f341d4f 305.5 KB Tue, 05 Mar 2024 09:29:02 GMT 4
9.0.0-preview.1-ci.20240217T191349+sha.2382b8bfd 303.96 KB Sat, 17 Feb 2024 19:14:20 GMT 4
9.0.0-preview.1-ci.20240217T184245+sha.c0c962c8b 304 KB Sat, 17 Feb 2024 18:43:18 GMT 5
9.0.0-preview.1-ci.20240214T141124+sha.ea0a10368 303.96 KB Wed, 14 Feb 2024 14:11:54 GMT 5
9.0.0-preview.1-ci.20240211T200852+sha.ba3431737 303.97 KB Sun, 11 Feb 2024 20:09:19 GMT 4