Add-Migration mapping DateTimeOffset properties to invalid 'datetimeoffset' column type

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
jamir.araujo
Posts: 22
Joined: Wed 13 Mar 2019 17:25

Add-Migration mapping DateTimeOffset properties to invalid 'datetimeoffset' column type

Post by jamir.araujo » Fri 07 Jan 2022 15:56

Hi, I'm using Devart.Data.PostgreSql.EFCore v7.23.2042 and notice an issue when using DateTimeOffset on an entity property.

When I run the Add-Migration command, the column type for the DateTimeOffset property is set to datetimeoffset which is not a valid column type for PostgreSQL. I believe the column type should be timestamp with time zone.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Add-Migration mapping DateTimeOffset properties to invalid 'datetimeoffset' column type

Post by Shalex » Sat 08 Jan 2022 13:41

Thank you for your report. You are working with EF Core 6, aren't you?

We have reproduced the issue and will notify you when it is fixed.

jamir.araujo
Posts: 22
Joined: Wed 13 Mar 2019 17:25

Re: Add-Migration mapping DateTimeOffset properties to invalid 'datetimeoffset' column type

Post by jamir.araujo » Tue 11 Jan 2022 18:29

Yes, I'm working with EF Core 6.

Post Reply