Devart Forums

I am using Entity Developer v 5.8.791 in model first mode, and Postgresql 9.5. When I create or modify an entity property of type "datetimeoffset" using the "Property Editor" dialog, the "Server Data Type" generated by Entity Developer is "timestamp with timezone". But this fails to be created on the database server. If I modify it to be "timestamp with time zone" (with a space character in "time zone") then it works fine. The server type that is automatically generated by Entity Developer should be fixed.

You are using the LinqConnect model (*.lqml), aren't you?

tom.puckett wrote:When I create or modify an entity property of type "datetimeoffset" using the "Property Editor" dialog, the "Server Data Type" generated by Entity Developer is "timestamp with timezone". But this fails to be created on the database server. If I modify it to be "timestamp with time zone" (with a space character in "time zone") then it works fine.

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

Yes, LinqConnect model.

Shalex wrote:You are using the LinqConnect model (*.lqml), aren't you?

tom.puckett wrote:When I create or modify an entity property of type "datetimeoffset" using the "Property Editor" dialog, the "Server Data Type" generated by Entity Developer is "timestamp with timezone". But this fails to be created on the database server. If I modify it to be "timestamp with time zone" (with a space character in "time zone") then it works fine.

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

The bug is fixed. We will notify you when the corresponding build of Entity Developer is available for download.

The bug with generating the "timestamp with time zone" columns in the Generate Database Script / Update Database From Model functionality is fixed in LinqConnect 4.5.976: http://forums.devart.com/viewtopic.php?f=31&t=33580.

Confirmed it's working now, thanks.