Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime
6.0.4
Prefix Reserved
See the version list below for details.
Install-Package Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime -Version 6.0.4
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime --version 6.0.4
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime" Version="6.0.4" />
paket add Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime --version 6.0.4
#r "nuget: Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime, 6.0.4"
// Install Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime as a Cake Addin
#addin nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime&version=6.0.4
// Install Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime as a Cake Tool
#tool nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime&version=6.0.4
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 |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net461 net462 net463 net47 net471 net472 net48 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
net6.0
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 6.0.4)
- Npgsql.NodaTime (>= 6.0.4)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime:
Package | Downloads |
---|---|
devprime.stack.state
DevPrime State |
|
SvrdSdk.AspNetCore
Package Description |
|
LS.Helpers.Hosting
.NET Core helpers for ASP.NET hosting |
GitHub repositories (1)
Showing the top 1 popular GitHub repositories that depend on Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime:
Repository | Stars |
---|---|
ErikEJ/EFCorePowerTools
Entity Framework Core Power Tools - reverse engineering, migrations and model visualization for EF Core
|
Version | Downloads | Last updated |
---|---|---|
7.0.0-preview.4 | 53 | 5/11/2022 |
7.0.0-preview.3 | 191 | 4/19/2022 |
7.0.0-preview.2 | 69 | 3/16/2022 |
7.0.0-preview.1 | 250 | 2/17/2022 |
6.0.4 | 14,772 | 4/19/2022 |
6.0.3 | 67,837 | 1/27/2022 |
6.0.2 | 80,704 | 12/22/2021 |
6.0.1 | 23,324 | 12/3/2021 |
6.0.0 | 21,575 | 11/9/2021 |
6.0.0-rc.2 | 969 | 10/14/2021 |
6.0.0-rc.1 | 1,036 | 9/24/2021 |
6.0.0-preview7 | 1,663 | 8/16/2021 |
6.0.0-preview6 | 199 | 7/31/2021 |
6.0.0-preview5 | 267 | 7/1/2021 |
6.0.0-preview4 | 279 | 5/27/2021 |
6.0.0-preview3 | 278 | 4/15/2021 |
6.0.0-preview2 | 226 | 3/11/2021 |
6.0.0-preview1 | 227 | 2/16/2021 |
5.0.10 | 255,963 | 9/15/2021 |
5.0.7 | 248,944 | 6/13/2021 |
5.0.6 | 67,691 | 5/11/2021 |
5.0.5.1 | 38,405 | 4/21/2021 |
5.0.5 | 7,485 | 4/16/2021 |
5.0.2 | 268,316 | 1/19/2021 |
5.0.1 | 55,714 | 12/12/2020 |
5.0.0 | 20,632 | 11/15/2020 |
5.0.0-rc2 | 4,082 | 10/15/2020 |
5.0.0-rc1 | 3,191 | 9/14/2020 |
5.0.0-preview8 | 346 | 8/27/2020 |
5.0.0-preview7 | 393 | 7/22/2020 |
5.0.0-preview6 | 929 | 6/26/2020 |
5.0.0-preview5 | 280 | 6/11/2020 |
5.0.0-preview4 | 346 | 5/19/2020 |
5.0.0-preview3 | 317 | 4/24/2020 |
5.0.0-preview2 | 399 | 4/2/2020 |
5.0.0-preview.2.20120.8 | 229 | 3/20/2020 |
3.1.18 | 9,101 | 8/27/2021 |
3.1.11 | 31,804 | 1/21/2021 |
3.1.4 | 297,200 | 5/29/2020 |
3.1.3 | 130,063 | 3/26/2020 |
3.1.2 | 16,902 | 2/20/2020 |
3.1.1 | 21,454 | 1/31/2020 |
3.1.0 | 21,569 | 12/4/2019 |
3.1.0-preview3 | 2,345 | 11/15/2019 |
3.1.0-preview2 | 294 | 11/6/2019 |
3.0.1 | 10,215 | 10/2/2019 |
3.0.0 | 6,486 | 9/26/2019 |
3.0.0-preview9 | 1,964 | 9/4/2019 |
3.0.0-preview8 | 423 | 8/15/2019 |
3.0.0-preview7 | 417 | 7/25/2019 |
3.0.0-preview5 | 483 | 5/6/2019 |
3.0.0-preview4 | 369 | 4/21/2019 |
3.0.0-preview3 | 405 | 3/12/2019 |
3.0.0-preview1 | 661 | 12/16/2018 |
2.2.4 | 61,019 | 5/21/2019 |
2.2.0 | 60,766 | 12/7/2018 |
2.1.1 | 206,352 | 7/1/2018 |
2.1.0 | 2,559 | 5/31/2018 |
2.1.0-rc1 | 688 | 5/8/2018 |