Page 1 of 1

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

Posted: Fri 07 Jan 2022 15:56
by jamir.araujo
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.

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

Posted: Sat 08 Jan 2022 13:41
by Shalex
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.

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

Posted: Tue 11 Jan 2022 18:29
by jamir.araujo
Yes, I'm working with EF Core 6.