Npgsql.EntityFrameworkCore.PostgreSQL 7.0.1
Npgsql Entity Framework Core provider for PostgreSQL
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.
Showing the top 20 packages that depend on Npgsql.EntityFrameworkCore.PostgreSQL.
| Packages | Downloads |
|---|---|
|
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL and SQLite
|
1 |
|
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, SQLite
|
1 |
|
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
|
4 |
|
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
|
5 |
|
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
|
6 |
|
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
|
13 |
|
Quantum.FrameworkNetCore
Used for set up Micro-Service.
|
9 |
.NET 6.0
- Microsoft.EntityFrameworkCore (>= 7.0.1 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.1 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.1 && < 8.0.0)
- Npgsql (>= 7.0.1)
.NET 7.0
- Microsoft.EntityFrameworkCore (>= 7.0.1 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Abstractions (>= 7.0.1 && < 8.0.0)
- Microsoft.EntityFrameworkCore.Relational (>= 7.0.1 && < 8.0.0)
- Npgsql (>= 7.0.1)
| Version | Downloads | Last updated |
|---|---|---|
| 9.0.0-rc.2 | 0 | 10/13/2024 |
| 9.0.0-rc.1 | 0 | 09/13/2024 |
| 9.0.0-preview.7 | 0 | 09/01/2024 |
| 9.0.0-preview.3 | 11 | 04/20/2024 |
| 9.0.0-preview.2 | 2 | 05/29/2024 |
| 9.0.0-preview.1 | 2 | 05/29/2024 |
| 8.0.10 | 0 | 10/17/2024 |
| 8.0.8 | 0 | 09/27/2024 |
| 8.0.4 | 4 | 05/29/2024 |
| 8.0.2 | 4 | 04/27/2024 |
| 8.0.0 | 6 | 05/29/2024 |
| 8.0.0-rc.2 | 12 | 04/10/2024 |
| 8.0.0-rc.1 | 3 | 04/27/2024 |
| 8.0.0-preview.7 | 5 | 04/27/2024 |
| 8.0.0-preview.4 | 5 | 04/27/2024 |
| 8.0.0-preview.3 | 5 | 05/10/2024 |
| 8.0.0-preview.2 | 2 | 05/02/2024 |
| 8.0.0-preview.1 | 3 | 05/15/2024 |
| 7.0.18 | 3 | 05/29/2024 |
| 7.0.11 | 4 | 04/27/2024 |
| 7.0.4 | 2 | 05/28/2024 |
| 7.0.3 | 2 | 05/23/2024 |
| 7.0.1 | 6 | 02/10/2023 |
| 7.0.0 | 2 | 05/10/2024 |
| 7.0.0-rc.2 | 4 | 05/15/2024 |
| 7.0.0-rc.1 | 5 | 04/27/2024 |
| 7.0.0-preview.7 | 5 | 05/18/2024 |
| 7.0.0-preview.6 | 3 | 05/19/2024 |
| 7.0.0-preview.5 | 5 | 05/24/2024 |
| 7.0.0-preview.4 | 3 | 05/11/2024 |
| 7.0.0-preview.2 | 5 | 05/15/2024 |
| 7.0.0-preview.1 | 3 | 06/19/2023 |
| 6.0.29 | 5 | 05/29/2024 |
| 6.0.22 | 4 | 04/27/2024 |
| 6.0.6 | 7 | 01/29/2023 |
| 6.0.5 | 4 | 05/15/2024 |
| 6.0.3 | 4 | 02/07/2023 |
| 6.0.2 | 2 | 05/19/2024 |
| 6.0.1 | 3 | 04/27/2024 |
| 6.0.0 | 6 | 01/29/2023 |
| 6.0.0-rc.1 | 2 | 05/22/2024 |
| 6.0.0-preview7 | 5 | 05/08/2024 |
| 6.0.0-preview6 | 4 | 06/19/2023 |
| 6.0.0-preview5 | 6 | 05/13/2024 |
| 6.0.0-preview4 | 4 | 04/27/2024 |
| 6.0.0-preview3 | 3 | 05/23/2024 |
| 6.0.0-preview2 | 3 | 05/05/2024 |
| 5.0.10 | 2 | 05/11/2024 |
| 5.0.5 | 3 | 05/14/2024 |
| 5.0.0 | 4 | 05/03/2024 |
| 3.1.18 | 3 | 05/25/2024 |
| 3.1.1 | 3 | 06/19/2023 |
| 3.0.0 | 4 | 05/22/2024 |
| 2.1.2 | 3 | 05/19/2024 |
| 2.1.1.1 | 4 | 06/19/2023 |
| 2.0.2 | 2 | 05/14/2024 |
| 2.0.1 | 2 | 05/18/2024 |
| 2.0.0 | 4 | 05/25/2024 |
| 1.1.1 | 4 | 05/20/2024 |
| 1.1.0 | 3 | 05/02/2024 |
| 1.0.1 | 2 | 05/11/2024 |
| 1.0.0 | 8 | 01/29/2023 |