npgsql-vnext - Npgsql.EntityFrameworkCore.PostgreSQL 8.0.0-preview.5-ci.20230601T113603+sha.0ce3dbf49

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 8.0.0-preview.5-ci.20230601T113603 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 8.0.0-preview.5-ci.20230601T113603 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 8.0.0-preview.5-ci.20230601T113603 --source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.0-preview.5-ci.20230601T113603" />
Copy to clipboard
source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 8.0.0-preview.5-ci.20230601T113603
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 8.0.0-preview.5-ci.20230601T113603 --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 "8.0.0-preview.5-ci.20230601T113603" -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 6.0
    • Microsoft.EntityFrameworkCore (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Relational (>= 8.0.0-preview.4.23259.3)
    • Npgsql (>= 8.0.0-preview.4)
  • .NETFramework 7.0
    • Microsoft.EntityFrameworkCore (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Relational (>= 8.0.0-preview.4.23259.3)
    • Npgsql (>= 8.0.0-preview.4)
  • .NETFramework 8.0
    • Microsoft.EntityFrameworkCore (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 8.0.0-preview.4.23259.3)
    • Microsoft.EntityFrameworkCore.Relational (>= 8.0.0-preview.4.23259.3)
    • Npgsql (>= 8.0.0-preview.4)
  • .NETFramework 6.0: 6.0.0.0
  • .NETFramework 7.0: 7.0.0.0
  • .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

45 total downloads
0 downloads for version 8.0.0-preview.5-ci.20230601T113603+sha.0ce3dbf49
Download (814.12 KB)
Download symbols (234.52 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
8.0.0-preview.5-ci.20230601T113603+sha.0ce3dbf49 814.12 KB Thu, 01 Jun 2023 11:36:34 GMT 0
8.0.0-preview.5-ci.20230525T115033+sha.3cce62a29 814.12 KB Thu, 25 May 2023 11:51:19 GMT 0
8.0.0-preview.5-ci.20230522T092340+sha.c9bc9c18b 814.3 KB Mon, 22 May 2023 09:24:19 GMT 0
8.0.0-preview.4-ci.20230517T113710+sha.297baffae 801.9 KB Wed, 17 May 2023 11:37:41 GMT 1
8.0.0-preview.4-ci.20230511T102101+sha.6682d5aec 801.9 KB Thu, 11 May 2023 10:21:35 GMT 1
8.0.0-preview.4-ci.20230509T105007+sha.51355cee8 801.88 KB Tue, 09 May 2023 10:50:42 GMT 1
8.0.0-preview.4-ci.20230428T163332+sha.5f8f665ef 801.9 KB Fri, 28 Apr 2023 16:34:16 GMT 0
8.0.0-preview.3-ci.20230331T114526+sha.36522183c 801.3 KB Fri, 31 Mar 2023 11:45:57 GMT 1
8.0.0-preview.3-ci.20230320T222636+sha.9f58e1867 801.33 KB Mon, 20 Mar 2023 22:27:05 GMT 1
8.0.0-preview.3-ci.20230319T192135+sha.1817efd55 801.34 KB Sun, 19 Mar 2023 19:22:05 GMT 1
8.0.0-preview.3-ci.20230319T152817+sha.fd831f7da 798.87 KB Sun, 19 Mar 2023 15:28:47 GMT 1
8.0.0-preview.2-ci.20230315T124129+sha.5ae141aef 798.87 KB Wed, 15 Mar 2023 12:42:04 GMT 1
8.0.0-preview.2-ci.20230314T200411+sha.1018a451d 798.4 KB Tue, 14 Mar 2023 20:04:42 GMT 1
8.0.0-preview.2-ci.20230307T164756+sha.a1dcfd0a8 798.38 KB Tue, 07 Mar 2023 16:49:14 GMT 1
8.0.0-preview.2-ci.20230306T151544+sha.00724919a 798.37 KB Mon, 06 Mar 2023 15:16:22 GMT 0
8.0.0-preview.1-ci.20230303T223405+sha.574a53ca6 798.38 KB Fri, 03 Mar 2023 22:34:45 GMT 1
8.0.0-preview.1-ci.20230302T144309+sha.cadbf7cfc 798.39 KB Thu, 02 Mar 2023 14:43:46 GMT 1
8.0.0-preview.1-ci.20230226T185208+sha.f76e0ede9 798.32 KB Sun, 26 Feb 2023 18:52:38 GMT 1
8.0.0-preview.1-ci.20230221T125140+sha.44c80ab1c 537.41 KB Tue, 21 Feb 2023 12:52:17 GMT 1
8.0.0-preview.1-ci.20230221T122121+sha.7713305dc 537.82 KB Tue, 21 Feb 2023 12:23:28 GMT 1
8.0.0-preview.1-ci.20230220T225109+sha.2c93728a3 537.83 KB Mon, 20 Feb 2023 22:51:37 GMT 1
8.0.0-preview.1-ci.20230218T122638+sha.6fafb3771 537.13 KB Sat, 18 Feb 2023 12:27:11 GMT 1
8.0.0-preview.1-ci.20230215T102203+sha.476ec0db2 537.21 KB Wed, 15 Feb 2023 10:23:01 GMT 1
8.0.0-preview.1-ci.20230202T105602+sha.4df4774e9 537.17 KB Thu, 02 Feb 2023 10:56:38 GMT 1
8.0.0-preview.1-ci.20230129T150323+sha.aa9ee5307 536.27 KB Sun, 29 Jan 2023 15:03:55 GMT 1
8.0.0-preview.1-ci.20230127T101033+sha.8fda2190d 535.19 KB Fri, 27 Jan 2023 10:11:04 GMT 1
8.0.0-preview.1-ci.20230116T222849+sha.db80fec88 535.17 KB Mon, 16 Jan 2023 22:29:21 GMT 1
8.0.0-preview.1-ci.20221219T112518+sha.3e4ef719b 534.86 KB Mon, 19 Dec 2022 11:25:47 GMT 3
8.0.0-preview.1-ci.20221201T122334+sha.957396141 534.74 KB Thu, 01 Dec 2022 12:24:18 GMT 1
8.0.0-preview.1-ci.20221125T203430+sha.8b8c60436 534.59 KB Fri, 25 Nov 2022 20:34:59 GMT 1
8.0.0-preview.1-ci.20221125T202310+sha.ded930d8e 534.58 KB Fri, 25 Nov 2022 20:23:40 GMT 1
8.0.0-preview.1-ci.20221115T114424+sha.e40f2f0bb 534.6 KB Tue, 15 Nov 2022 11:44:50 GMT 1
8.0.0-preview.1-ci.20221109T211223+sha.ddeeceea6 534.32 KB Wed, 09 Nov 2022 21:12:50 GMT 1
7.0.0-rtm-ci.20221109T131132+sha.97d2f374f 534.29 KB Wed, 09 Nov 2022 13:12:04 GMT 3
7.0.0-rtm-ci.20221109T081025+sha.8ee39e34a 532.01 KB Wed, 09 Nov 2022 08:10:57 GMT 1
7.0.0-rtm-ci.20221109T072449+sha.58fa30bb7 532.1 KB Wed, 09 Nov 2022 07:25:18 GMT 1
7.0.0-rtm-ci.20221103T170527+sha.835e2ad39 532.11 KB Thu, 03 Nov 2022 17:06:00 GMT 1
7.0.0-rtm-ci.20221020T085759+sha.2e06eb40c 532.08 KB Thu, 20 Oct 2022 08:58:35 GMT 1
7.0.0-rtm-ci.20221019T232848+sha.7886196b9 532.19 KB Wed, 19 Oct 2022 23:29:20 GMT 1
7.0.0-rtm-ci.20221016T230856+sha.3a26ceb38 531.61 KB Sun, 16 Oct 2022 23:09:26 GMT 1
7.0.0-rtm-ci.20221016T203230+sha.0ff49118d 530.02 KB Sun, 16 Oct 2022 20:33:07 GMT 1
7.0.0-rtm-ci.20221015T193629+sha.95aa5c44d 528.63 KB Sat, 15 Oct 2022 19:37:35 GMT 1
7.0.0-rtm-ci.20221015T190409+sha.922fa77d4 528.69 KB Sat, 15 Oct 2022 19:04:40 GMT 1
7.0.0-rtm-ci.20221015T180544+sha.dd8eec069 528.71 KB Sat, 15 Oct 2022 18:06:16 GMT 1
7.0.0-rtm-ci.20221015T140004+sha.c788797d4 528.41 KB Sat, 15 Oct 2022 14:00:43 GMT 0
7.0.0-rtm-ci.20221015T133520+sha.aea5d05f9 527.68 KB Sat, 15 Oct 2022 13:35:55 GMT 0
7.0.0-rtm-ci.20221015T124028+sha.869e4c798 523.89 KB Sat, 15 Oct 2022 12:40:58 GMT 1
7.0.0-rtm-ci.20221014T112125+sha.af5ef17f0 523.95 KB Fri, 14 Oct 2022 11:22:01 GMT 1
7.0.0-rtm-ci.20221012T154048+sha.64ee8f6ab 523.96 KB Wed, 12 Oct 2022 15:41:20 GMT 0
7.0.0-rtm-ci.20221011T223202+sha.43b067eec 522.62 KB Tue, 11 Oct 2022 22:32:33 GMT 0