Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime
10.0.0-rc.2
Prefix Reserved
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime --version 10.0.0-rc.2
NuGet\Install-Package Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime -Version 10.0.0-rc.2
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime" Version="10.0.0-rc.2" />
<PackageVersion Include="Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime" Version="10.0.0-rc.2" />
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime" />
paket add Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime --version 10.0.0-rc.2
#r "nuget: Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime, 10.0.0-rc.2"
#:package Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime@10.0.0-rc.2
#addin nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime&version=10.0.0-rc.2&prerelease
#tool nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime&version=10.0.0-rc.2&prerelease
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.
This package is a plugin which allows you to use the NodaTime date/time library when interacting with PostgreSQL; this provides a better and safer API for dealing with date and time data.
To use the plugin, simply add UseNodaTime as below and use NodaTime types in your entity properties:
await using var ctx = new BlogContext();
await ctx.Database.EnsureDeletedAsync();
await ctx.Database.EnsureCreatedAsync();
// Insert a Blog
ctx.Blogs.Add(new()
{
Name = "FooBlog",
CreationTime = SystemClock.Instance.GetCurrentInstant()
});
await ctx.SaveChangesAsync();
// Query all blogs created in 2020 or after
var newBlogs = await ctx.Blogs.Where(b => b.CreationTime >= Instant.FromUtc(2020, 1, 1, 0, 0, 0)).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",
o => o.UseNodaTime());
}
public class Blog
{
public int Id { get; set; }
public string Name { get; set; }
public Instant CreationTime { get; set; }
}
The plugin also supports translating most NodaTime methods and properties into corresponding PostgreSQL date/time operations. For more information, see the NodaTime plugin documentation page.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
net10.0
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.0-rc.2)
- Npgsql.NodaTime (>= 10.0.0-rc.1)
NuGet packages (16)
Showing the top 5 NuGet packages that depend on Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime:
| Package | Downloads |
|---|---|
|
devprime.stack.state
DevPrime State |
|
|
SvrdSdk.AspNetCore
Package Description |
|
|
EasyDesk.CleanArchitecture.Dal.PostgreSql
Utilities for the SqlServer data access layer of the clean architecture as seen by EasyDesk. |
|
|
CockroachDB.EFCore.Provider
Package Description |
|
|
LS.Helpers.Hosting
.NET Core helpers for ASP.NET hosting |
GitHub repositories (6)
Showing the top 6 popular GitHub repositories that depend on Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime:
| Repository | Stars |
|---|---|
|
ChilliCream/graphql-platform
Welcome to the home of the Hot Chocolate GraphQL server for .NET, the Strawberry Shake GraphQL client for .NET and Nitro the awesome Monaco based GraphQL IDE.
|
|
|
linq2db/linq2db
Linq to database provider.
|
|
|
ErikEJ/EFCorePowerTools
Entity Framework Core Power Tools - reverse engineering, migrations and model visualization in Visual Studio & CLI
|
|
|
linq2db/linq2db.EntityFrameworkCore
Bring power of Linq To DB to Entity Framework Core projects
|
|
|
carlreid/StreamMaster
A powerful M3U proxy and stream management platform for Plex DVR, Emby, Jellyfin Live TV (and more)
|
|
|
NosCoreIO/NosCore
NosCore is a Nostale emulator in c# (.Net 9) using DotNetty / Entity Framework / WebAPI / Autofac / Mapster / Serilog
|
| Version | Downloads | Last Updated |
|---|---|---|
| 10.0.0-rc.2 | 948 | 10/16/2025 |
| 10.0.0-rc.1 | 1,724 | 9/10/2025 |
| 10.0.0-preview.7 | 1,041 | 8/17/2025 |
| 10.0.0-preview.5 | 1,715 | 6/11/2025 |
| 10.0.0-preview.3 | 473 | 4/12/2025 |
| 10.0.0-preview.2 | 460 | 3/24/2025 |
| 10.0.0-preview.1 | 150 | 3/1/2025 |
| 9.0.4 | 890,106 | 3/1/2025 |
| 9.0.3 | 184,878 | 1/17/2025 |
| 9.0.2 | 107,096 | 12/7/2024 |
| 9.0.1 | 71,394 | 11/19/2024 |
| 9.0.0 | 10,500 | 11/18/2024 |
| 9.0.0-rc.2 | 3,630 | 10/13/2024 |
| 9.0.0-rc.1 | 1,048 | 9/13/2024 |
| 9.0.0-preview.7 | 323 | 9/1/2024 |
| 9.0.0-preview.3 | 740 | 4/12/2024 |
| 9.0.0-preview.2 | 162 | 3/22/2024 |
| 9.0.0-preview.1 | 197 | 2/14/2024 |
| 8.0.11 | 404,258 | 11/18/2024 |
| 8.0.10 | 357,804 | 10/17/2024 |
| 8.0.8 | 201,962 | 9/27/2024 |
| 8.0.4 | 828,625 | 5/11/2024 |
| 8.0.2 | 376,508 | 2/17/2024 |
| 8.0.0 | 342,388 | 11/21/2023 |
| 8.0.0-rc.2 | 14,690 | 10/11/2023 |
| 8.0.0-rc.1 | 1,525 | 9/14/2023 |
| 8.0.0-preview.7 | 357 | 8/18/2023 |
| 8.0.0-preview.4 | 4,568 | 5/20/2023 |
| 8.0.0-preview.3 | 251 | 4/24/2023 |
| 8.0.0-preview.2 | 398 | 3/20/2023 |
| 8.0.0-preview.1 | 348 | 3/3/2023 |
| 7.0.18 | 47,400 | 5/11/2024 |
| 7.0.11 | 352,788 | 9/15/2023 |
| 7.0.4 | 463,494 | 4/24/2023 |
| 7.0.3 | 440,400 | 2/15/2023 |
| 7.0.1 | 293,030 | 12/17/2022 |
| 7.0.0 | 74,380 | 11/9/2022 |
| 7.0.0-rc.2 | 2,689 | 10/11/2022 |
| 7.0.0-rc.1 | 885 | 9/16/2022 |
| 7.0.0-preview.7 | 858 | 8/9/2022 |
| 7.0.0-preview.6 | 616 | 7/13/2022 |
| 7.0.0-preview.5 | 382 | 6/19/2022 |
| 7.0.0-preview.4 | 545 | 5/11/2022 |
| 7.0.0-preview.3 | 464 | 4/19/2022 |
| 7.0.0-preview.2 | 317 | 3/16/2022 |
| 7.0.0-preview.1 | 609 | 2/17/2022 |
| 6.0.29 | 40,472 | 5/11/2024 |
| 6.0.22 | 56,149 | 9/15/2023 |
| 6.0.8 | 298,619 | 12/17/2022 |
| 6.0.7 | 350,782 | 9/16/2022 |
| 6.0.6 | 299,228 | 8/4/2022 |
| 6.0.5 | 247,360 | 6/19/2022 |
| 6.0.4 | 258,372 | 4/19/2022 |
| 6.0.3 | 357,503 | 1/27/2022 |
| 6.0.2 | 234,490 | 12/22/2021 |
| 6.0.1 | 115,796 | 12/3/2021 |
| 6.0.0 | 82,786 | 11/9/2021 |
| 6.0.0-rc.2 | 1,516 | 10/14/2021 |
| 6.0.0-rc.1 | 1,270 | 9/24/2021 |
| 6.0.0-preview7 | 2,506 | 8/16/2021 |
| 6.0.0-preview6 | 1,030 | 7/31/2021 |
| 6.0.0-preview5 | 1,113 | 7/1/2021 |
| 6.0.0-preview4 | 1,087 | 5/27/2021 |
| 6.0.0-preview3 | 1,132 | 4/15/2021 |
| 6.0.0-preview2 | 1,154 | 3/11/2021 |
| 6.0.0-preview1 | 1,133 | 2/16/2021 |
| 5.0.10 | 360,686 | 9/15/2021 |
| 5.0.7 | 275,380 | 6/13/2021 |
| 5.0.6 | 75,313 | 5/11/2021 |
| 5.0.5.1 | 48,981 | 4/21/2021 |
| 5.0.5 | 9,524 | 4/16/2021 |
| 5.0.2 | 316,000 | 1/19/2021 |
| 5.0.1 | 59,774 | 12/12/2020 |
| 5.0.0 | 22,929 | 11/15/2020 |
| 5.0.0-rc2 | 4,386 | 10/15/2020 |
| 5.0.0-rc1 | 4,132 | 9/14/2020 |
| 5.0.0-preview8 | 1,235 | 8/27/2020 |
| 5.0.0-preview7 | 1,234 | 7/22/2020 |
| 5.0.0-preview6 | 1,828 | 6/26/2020 |
| 5.0.0-preview5 | 1,161 | 6/11/2020 |
| 5.0.0-preview4 | 1,242 | 5/19/2020 |
| 5.0.0-preview3 | 1,170 | 4/24/2020 |
| 5.0.0-preview2 | 1,298 | 4/2/2020 |
| 5.0.0-preview.2.20120.8 | 483 | 3/20/2020 |
| 3.1.18 | 92,615 | 8/27/2021 |
| 3.1.11 | 57,244 | 1/21/2021 |
| 3.1.4 | 338,266 | 5/29/2020 |
| 3.1.3 | 136,183 | 3/26/2020 |
| 3.1.2 | 18,962 | 2/20/2020 |
| 3.1.1 | 28,635 | 1/31/2020 |
| 3.1.0 | 31,678 | 12/4/2019 |
| 3.1.0-preview3 | 3,227 | 11/15/2019 |
| 3.1.0-preview2 | 1,204 | 11/6/2019 |
| 3.0.1 | 11,924 | 10/2/2019 |
| 3.0.0 | 7,656 | 9/26/2019 |
| 3.0.0-preview9 | 2,850 | 9/4/2019 |
| 3.0.0-preview8 | 1,304 | 8/15/2019 |
| 3.0.0-preview7 | 1,321 | 7/25/2019 |
| 3.0.0-preview5 | 1,371 | 5/6/2019 |
| 3.0.0-preview4 | 1,246 | 4/21/2019 |
| 3.0.0-preview3 | 1,313 | 3/12/2019 |
| 3.0.0-preview1 | 1,666 | 12/16/2018 |
| 2.2.4 | 71,300 | 5/21/2019 |
| 2.2.0 | 64,415 | 12/7/2018 |
| 2.1.1 | 208,534 | 7/1/2018 |
| 2.1.0 | 8,264 | 5/31/2018 |
| 2.1.0-rc1 | 1,995 | 5/8/2018 |