npgsql-vnext - Npgsql.EntityFrameworkCore.PostgreSQL 7.0.0-rc.1-ci.20220817T223219+sha.13bc4ebe2

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.0-rc.1-ci.20220817T223219 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.0-rc.1-ci.20220817T223219 -Source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard

> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-rc.1-ci.20220817T223219 --source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

Copy to clipboard
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.0-rc.1-ci.20220817T223219" />
Copy to clipboard
source https://www.myget.org/F/npgsql-vnext/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 7.0.0-rc.1-ci.20220817T223219
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-rc.1-ci.20220817T223219 --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 "7.0.0-rc.1-ci.20220817T223219" -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 (>= 7.0.0-rc.1.22410.9)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.0-rc.1.22410.9)
    • Microsoft.EntityFrameworkCore.Relational (>= 7.0.0-rc.1.22410.9)
    • Npgsql (>= 7.0.0-preview.7)
  • .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

Unknown

Tags

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

Info

11 total downloads
0 downloads for version 7.0.0-rc.1-ci.20220817T223219+sha.13bc4ebe2
Download (207.41 KB)
Download symbols (75.54 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
7.0.0-rc.1-ci.20220817T223219+sha.13bc4ebe2 207.41 KB Wed, 17 Aug 2022 22:32:44 GMT 0
7.0.0-rc.1-ci.20220805T100738+sha.a1aa03edc 206.54 KB Fri, 05 Aug 2022 10:08:01 GMT 1
7.0.0-rc.1-ci.20220729T153423+sha.de02c160c 204.09 KB Fri, 29 Jul 2022 15:34:52 GMT 0
7.0.0-preview.7-ci.20220721T135714+sha.5aa5336d0 202.61 KB Thu, 21 Jul 2022 13:57:44 GMT 0
7.0.0-preview.7-ci.20220721T124521+sha.0cb6bb762 202.66 KB Thu, 21 Jul 2022 12:45:46 GMT 0
7.0.0-preview.7-ci.20220720T175616+sha.895455367 202.21 KB Wed, 20 Jul 2022 17:56:45 GMT 0
7.0.0-preview.7-ci.20220720T172209+sha.2814166aa 202.2 KB Wed, 20 Jul 2022 17:22:34 GMT 0
7.0.0-preview.7-ci.20220710T100813+sha.4da795468 202.21 KB Sun, 10 Jul 2022 10:08:43 GMT 0
7.0.0-preview.7-ci.20220710T083247+sha.a35240913 202.05 KB Sun, 10 Jul 2022 08:33:09 GMT 0
7.0.0-preview.7-ci.20220710T074920+sha.0d85c2c7e 202.05 KB Sun, 10 Jul 2022 07:49:48 GMT 0
7.0.0-preview.7-ci.20220709T234355+sha.1eed21e08 202.05 KB Sat, 09 Jul 2022 23:44:18 GMT 0
7.0.0-preview.7-ci.20220709T223708+sha.82a758cdd 201.92 KB Sat, 09 Jul 2022 22:37:33 GMT 0
7.0.0-preview.7-ci.20220709T213610+sha.037cffd01 199.43 KB Sat, 09 Jul 2022 21:36:36 GMT 0
7.0.0-preview.7-ci.20220624T064832+sha.ba7d2a58a 197.85 KB Fri, 24 Jun 2022 06:48:55 GMT 0
7.0.0-preview.7-ci.20220623T102524+sha.642f73a64 197.85 KB Thu, 23 Jun 2022 10:25:44 GMT 0
7.0.0-preview.6-ci.20220623T101103+sha.266ab16bd 197.85 KB Thu, 23 Jun 2022 10:11:23 GMT 0
7.0.0-preview.6-ci.20220621T195358+sha.227a4bcc4 197.83 KB Tue, 21 Jun 2022 19:54:20 GMT 0
7.0.0-preview.6-ci.20220620T201817+sha.6a1d7a81e 197.9 KB Mon, 20 Jun 2022 20:18:41 GMT 0
7.0.0-preview.6-ci.20220619T131323+sha.8deb13cb7 197.6 KB Sun, 19 Jun 2022 13:13:49 GMT 0
7.0.0-preview.6-ci.20220613T115224+sha.40a7a133b 197.62 KB Mon, 13 Jun 2022 11:52:55 GMT 0
7.0.0-preview.6-ci.20220606T095738+sha.d9a236c67 197.61 KB Mon, 06 Jun 2022 09:58:01 GMT 0
7.0.0-preview.6-ci.20220604T211350+sha.28999d56b 197.64 KB Sat, 04 Jun 2022 21:14:15 GMT 0
7.0.0-preview.6-ci.20220604T210458+sha.596ef7e18 197.49 KB Sat, 04 Jun 2022 21:05:28 GMT 0
7.0.0-preview.6-ci.20220604T170747+sha.101647020 197.47 KB Sat, 04 Jun 2022 17:08:15 GMT 0
7.0.0-preview.6-ci.20220601T070118+sha.e672715e3 195.82 KB Wed, 01 Jun 2022 07:01:49 GMT 0
7.0.0-preview.6-ci.20220527T185630+sha.d55c90d47 195.78 KB Fri, 27 May 2022 18:56:56 GMT 0
7.0.0-preview.6-ci.20220525T151800+sha.edca1f235 195.77 KB Wed, 25 May 2022 15:18:24 GMT 0
7.0.0-preview.6-ci.20220525T105037+sha.1ff125682 195.78 KB Wed, 25 May 2022 10:51:00 GMT 0
7.0.0-preview.5-ci.20220525T103141+sha.067006512 195.77 KB Wed, 25 May 2022 10:32:09 GMT 0
7.0.0-preview.5-ci.20220525T102524+sha.067006512 195.77 KB Wed, 25 May 2022 10:25:45 GMT 0
7.0.0-preview.5-ci.20220523T080941+sha.46782f0c9 195.76 KB Mon, 23 May 2022 08:10:07 GMT 0
7.0.0-preview.5-ci.20220519T080513+sha.e946af86d 194.32 KB Thu, 19 May 2022 08:05:37 GMT 0
7.0.0-preview.5-ci.20220517T210813+sha.ee502382c 194.3 KB Tue, 17 May 2022 21:08:36 GMT 0
7.0.0-preview.5-ci.20220517T123814+sha.4b93f7400 194.34 KB Tue, 17 May 2022 12:38:36 GMT 0
7.0.0-preview.5-ci.20220517T100442+sha.3880d96e4 193.73 KB Tue, 17 May 2022 10:05:04 GMT 0
7.0.0-preview.5-ci.20220517T094739+sha.363761078 193.63 KB Tue, 17 May 2022 09:48:10 GMT 0
7.0.0-preview.5-ci.20220517T091716+sha.4de9b5417 193.45 KB Tue, 17 May 2022 09:17:43 GMT 0
7.0.0-preview.5-ci.20220515T215332+sha.227488143 193.45 KB Sun, 15 May 2022 21:53:53 GMT 0
7.0.0-preview.5-ci.20220511T113819+sha.aeadd4cc0 193.45 KB Wed, 11 May 2022 11:38:42 GMT 0
7.0.0-preview.5-ci.20220511T100629+sha.0959e07fc 193.46 KB Wed, 11 May 2022 10:07:08 GMT 0
7.0.0-preview.5-ci.20220510T230744+sha.95c8667b5 193.46 KB Tue, 10 May 2022 23:08:08 GMT 0
7.0.0-preview.5-ci.20220507T195025+sha.52f68c342 193.23 KB Sat, 07 May 2022 19:50:50 GMT 0
7.0.0-preview.5-ci.20220506T111204+sha.bb9617f8a 191.57 KB Fri, 06 May 2022 11:12:27 GMT 0
7.0.0-preview.5-ci.20220506T093225+sha.94648a383 191.56 KB Fri, 06 May 2022 09:32:52 GMT 0
7.0.0-preview.5-ci.20220505T103555+sha.fed78ec7d 191.63 KB Thu, 05 May 2022 10:36:19 GMT 0
7.0.0-preview.5-ci.20220426T165043+sha.e11cbcba0 191.64 KB Tue, 26 Apr 2022 16:51:07 GMT 2
7.0.0-preview.5-ci.20220425T090556+sha.c9a2f84e4 191.63 KB Mon, 25 Apr 2022 09:06:16 GMT 3
7.0.0-preview.5-ci.20220421T102554+sha.a5fbba103 191.52 KB Thu, 21 Apr 2022 10:26:18 GMT 2
7.0.0-preview.5-ci.20220420T085517+sha.4f2da8baa 191.52 KB Wed, 20 Apr 2022 08:55:45 GMT 2
7.0.0-preview.4-ci.20220420T084841+sha.1c8cb25aa 191.54 KB Wed, 20 Apr 2022 08:49:45 GMT 1