npgsql-vnext - Npgsql.EntityFrameworkCore.PostgreSQL 9.0.0-preview.4-ci.20240518T175510+sha.6b3ca689d

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 9.0.0-preview.4-ci.20240518T175510 -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.4-ci.20240518T175510 -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.4-ci.20240518T175510 --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.4-ci.20240518T175510" />
Copy to clipboard
source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 9.0.0-preview.4-ci.20240518T175510
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.0-preview.4-ci.20240518T175510 --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.4-ci.20240518T175510" -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.3.24172.4)
    • Microsoft.EntityFrameworkCore.Relational (>= 9.0.0-preview.3.24172.4)
    • Npgsql (>= 8.0.3)
  • .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

388 total downloads
0 downloads for version 9.0.0-preview.4-ci.20240518T175510+sha.6b3ca689d
Download (311.4 KB)
Download symbols (88.38 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
9.0.0-preview.4-ci.20240518T175510+sha.6b3ca689d 311.4 KB Sat, 18 May 2024 17:55:31 GMT 0
9.0.0-preview.4-ci.20240516T124658+sha.d5de63149 306.89 KB Thu, 16 May 2024 12:47:17 GMT 0
9.0.0-preview.4-ci.20240511T083656+sha.f69fc1d8e 306.9 KB Sat, 11 May 2024 08:37:14 GMT 0
9.0.0-preview.3-ci.20240412T143842+sha.f38a96cee 306.89 KB Fri, 12 Apr 2024 14:39:02 GMT 0
9.0.0-preview.3-ci.20240404T143221+sha.17fa8de6d 305.38 KB Thu, 04 Apr 2024 14:32:52 GMT 0
9.0.0-preview.3-ci.20240403T110140+sha.ac91e9a0c 305.93 KB Wed, 03 Apr 2024 11:02:07 GMT 0
9.0.0-preview.3-ci.20240401T091105+sha.dcef41511 305.69 KB Mon, 01 Apr 2024 09:12:05 GMT 0
9.0.0-preview.3-ci.20240322T155220+sha.7f6bdbe94 305.72 KB Fri, 22 Mar 2024 15:52:46 GMT 0
9.0.0-preview.1-ci.20240320T210055+sha.533b9d31a 305.7 KB Wed, 20 Mar 2024 21:01:20 GMT 0
9.0.0-preview.1-ci.20240305T092832+sha.08f341d4f 305.5 KB Tue, 05 Mar 2024 09:29:02 GMT 0
9.0.0-preview.1-ci.20240217T191349+sha.2382b8bfd 303.96 KB Sat, 17 Feb 2024 19:14:20 GMT 1
9.0.0-preview.1-ci.20240217T184245+sha.c0c962c8b 304 KB Sat, 17 Feb 2024 18:43:18 GMT 2
9.0.0-preview.1-ci.20240214T141124+sha.ea0a10368 303.96 KB Wed, 14 Feb 2024 14:11:54 GMT 2
9.0.0-preview.1-ci.20240211T200852+sha.ba3431737 303.97 KB Sun, 11 Feb 2024 20:09:19 GMT 1
9.0.0-preview.1-ci.20240125T161423+sha.35f0fd5a7 302.53 KB Thu, 25 Jan 2024 16:14:53 GMT 1
9.0.0-preview.1-ci.20240106T173826+sha.e6d545ace 302.52 KB Sat, 06 Jan 2024 17:38:52 GMT 2
9.0.0-preview.1-ci.20240106T065012+sha.5c744a82f 301.7 KB Sat, 06 Jan 2024 06:50:38 GMT 2
9.0.0-preview.1-ci.20240105T091030+sha.34e6242d5 301.51 KB Fri, 05 Jan 2024 09:10:56 GMT 2
9.0.0-preview.1-ci.20240104T014555+sha.159be1984 301.5 KB Thu, 04 Jan 2024 01:46:22 GMT 2
9.0.0-preview.1-ci.20231223T160420+sha.1cb8fb5d6 301.5 KB Sat, 23 Dec 2023 16:04:44 GMT 2
9.0.0-preview.1-ci.20231219T081426+sha.10aebeb90 301.27 KB Tue, 19 Dec 2023 08:14:58 GMT 3
9.0.0-preview.1-ci.20231218T144204+sha.e9f1ded61 301.27 KB Mon, 18 Dec 2023 14:42:25 GMT 3
9.0.0-preview.1-ci.20231218T115848+sha.74790424d 301.27 KB Mon, 18 Dec 2023 11:59:20 GMT 2
9.0.0-preview.1-ci.20231218T102559+sha.adff7ad1b 301.17 KB Mon, 18 Dec 2023 10:26:33 GMT 2
9.0.0-preview.1-ci.20231217T054148+sha.718b939c8 300.48 KB Sun, 17 Dec 2023 05:42:17 GMT 2
9.0.0-preview.1-ci.20231216T164307+sha.a69ba3e7e 300.48 KB Sat, 16 Dec 2023 16:43:32 GMT 2
9.0.0-preview.1-ci.20231216T082549+sha.eda534a65 300.49 KB Sat, 16 Dec 2023 08:26:24 GMT 3
9.0.0-preview.1-ci.20231211T103025+sha.1f724d3af 300.48 KB Mon, 11 Dec 2023 10:30:59 GMT 2
9.0.0-preview.1-ci.20231205T193500+sha.0a795e342 300.37 KB Tue, 05 Dec 2023 19:35:26 GMT 2
9.0.0-preview.1-ci.20231204T145137+sha.91ccdf67b 300.37 KB Mon, 04 Dec 2023 14:52:14 GMT 2
9.0.0-preview.1-ci.20231128T121557+sha.631b33026 300.17 KB Tue, 28 Nov 2023 12:16:27 GMT 3
9.0.0-preview.1-ci.20231128T121016+sha.70039b6f6 300.1 KB Tue, 28 Nov 2023 12:10:42 GMT 2
9.0.0-preview.1-ci.20231121T012147+sha.060b9c618 300.1 KB Tue, 21 Nov 2023 01:22:19 GMT 4
8.0.0-rtm-ci.20231120T112609+sha.9bbb19dd7 300.09 KB Mon, 20 Nov 2023 11:26:35 GMT 4
8.0.0-rtm-ci.20231120T112001+sha.dd3c6a21a 300.09 KB Mon, 20 Nov 2023 11:20:24 GMT 3
8.0.0-rtm-ci.20231119T221732+sha.4464d47f0 299.98 KB Sun, 19 Nov 2023 22:17:56 GMT 4
8.0.0-rtm-ci.20231118T155259+sha.fa5ba2eb0 299.89 KB Sat, 18 Nov 2023 15:53:25 GMT 6
8.0.0-rtm-ci.20231117T222455+sha.92f881ccc 298.74 KB Fri, 17 Nov 2023 22:25:18 GMT 3
8.0.0-rtm-ci.20231117T104559+sha.9792445e8 297.84 KB Fri, 17 Nov 2023 10:46:21 GMT 3
8.0.0-rtm-ci.20231116T125239+sha.8568b17ef 296.53 KB Thu, 16 Nov 2023 12:53:01 GMT 4
8.0.0-rtm-ci.20231116T011124+sha.4cfcd4f2a 296.51 KB Thu, 16 Nov 2023 01:11:51 GMT 3
8.0.0-rtm-ci.20231116T001510+sha.be39b8325 294.59 KB Thu, 16 Nov 2023 00:15:35 GMT 3
8.0.0-rtm-ci.20231115T131924+sha.4a5f96213 291.6 KB Wed, 15 Nov 2023 13:19:48 GMT 6
8.0.0-rtm-ci.20231115T010942+sha.b30700b27 289.92 KB Wed, 15 Nov 2023 01:10:06 GMT 5
8.0.0-rtm-ci.20231113T150204+sha.ba2bae495 289.92 KB Mon, 13 Nov 2023 15:02:43 GMT 3
8.0.0-rtm-ci.20231113T121359+sha.a173de7fd 289.87 KB Mon, 13 Nov 2023 12:14:36 GMT 3
8.0.0-rtm-ci.20231109T120422+sha.ec877ca9a 289.88 KB Thu, 09 Nov 2023 12:04:49 GMT 261
8.0.0-rtm-ci.20231107T154956+sha.4a7ef9724 289.88 KB Tue, 07 Nov 2023 15:50:33 GMT 3
8.0.0-preview.7-ci.20230825T111820+sha.dd71bd7b3 280.66 KB Fri, 25 Aug 2023 11:19:03 GMT 20
8.0.0-preview.5-ci.20230818T093445+sha.171345ecf 816.35 KB Fri, 18 Aug 2023 09:35:19 GMT 5