npgsql-unstable - Npgsql.EntityFrameworkCore.PostgreSQL 7.0.0-preview.1-ci.20211216T130245+sha.cf4f23ecc

PostgreSQL/Npgsql provider for Entity Framework Core.

PM> Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.0-preview.1-ci.20211216T130245 -Source https://www.myget.org/F/npgsql-unstable/api/v3/index.json

Copy to clipboard

> nuget.exe install Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.0-preview.1-ci.20211216T130245 -Source https://www.myget.org/F/npgsql-unstable/api/v3/index.json

Copy to clipboard

> dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-preview.1-ci.20211216T130245 --source https://www.myget.org/F/npgsql-unstable/api/v3/index.json

Copy to clipboard
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.0-preview.1-ci.20211216T130245" />
Copy to clipboard
source https://www.myget.org/F/npgsql-unstable/api/v3/index.json

nuget Npgsql.EntityFrameworkCore.PostgreSQL  ~> 7.0.0-preview.1-ci.20211216T130245
Copy to clipboard

> choco install Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-preview.1-ci.20211216T130245 --source https://www.myget.org/F/npgsql-unstable/api/v2

Copy to clipboard
Import-Module PowerShellGet
Register-PSRepository -Name "npgsql-unstable" -SourceLocation "https://www.myget.org/F/npgsql-unstable/api/v2"
Install-Module -Name "Npgsql.EntityFrameworkCore.PostgreSQL" -RequiredVersion "7.0.0-preview.1-ci.20211216T130245" -Repository "npgsql-unstable" -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-unstable/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.0)
    • Microsoft.EntityFrameworkCore.Abstractions (>= 6.0.0)
    • Microsoft.EntityFrameworkCore.Relational (>= 6.0.0)
    • Npgsql (>= 7.0.0-preview.1-ci.20211203T135215)
  • .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

49 total downloads
3 downloads for version 7.0.0-preview.1-ci.20211216T130245+sha.cf4f23ecc
Download (192.16 KB)
Download symbols (70 KB)
Found on the current feed only

Package history

Version Size Last updated Downloads Mirrored?
7.0.0-preview.1-ci.20211219T115250+sha.ccf49a97d 191.48 KB Sun, 19 Dec 2021 11:53:17 GMT 3
7.0.0-preview.1-ci.20211219T114849+sha.e4bf8f963 191.49 KB Sun, 19 Dec 2021 11:49:16 GMT 4
7.0.0-preview.1-ci.20211218T231127+sha.88b0d7c6b 191.49 KB Sat, 18 Dec 2021 23:11:50 GMT 2
7.0.0-preview.1-ci.20211217T191249+sha.324d9fa97 191.3 KB Fri, 17 Dec 2021 19:13:11 GMT 4
7.0.0-preview.1-ci.20211217T121206+sha.0d227b364 191.27 KB Fri, 17 Dec 2021 12:12:26 GMT 4
7.0.0-preview.1-ci.20211216T135052+sha.1d313b35c 191.26 KB Thu, 16 Dec 2021 13:51:12 GMT 3
7.0.0-preview.1-ci.20211216T130245+sha.cf4f23ecc 192.16 KB Thu, 16 Dec 2021 13:03:08 GMT 3
7.0.0-preview.1-ci.20211216T124046+sha.a44bca1c9 196.59 KB Thu, 16 Dec 2021 12:41:12 GMT 4
7.0.0-preview.1-ci.20211216T102600+sha.cd6475766 196.6 KB Thu, 16 Dec 2021 10:26:28 GMT 2
7.0.0-preview.1-ci.20211215T152005+sha.94fb3227b 196.6 KB Wed, 15 Dec 2021 15:20:27 GMT 3
7.0.0-preview.1-ci.20211213T190315+sha.d00cafb9e 196.12 KB Mon, 13 Dec 2021 19:03:42 GMT 4
7.0.0-preview.1-ci.20211208T114821+sha.ea14ba0f3 196.09 KB Wed, 08 Dec 2021 11:48:58 GMT 3
7.0.0-preview.1-ci.20211206T164712+sha.dcc3eb8a8 196.09 KB Mon, 06 Dec 2021 16:47:36 GMT 3
7.0.0-preview.1-ci.20211203T145444+sha.a517c5161 196.09 KB Fri, 03 Dec 2021 14:55:08 GMT 3
7.0.0-preview.1-ci.20211203T124752+sha.6970d7d7a 196.15 KB Fri, 03 Dec 2021 12:48:12 GMT 2
7.0.0-preview.1-ci.20211130T103753+sha.976247987 196.02 KB Tue, 30 Nov 2021 10:38:16 GMT 2