support of functions with time data type arguments

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
ssnz
Posts: 19
Joined: Mon 20 Aug 2018 21:15

support of functions with time data type arguments

Post by ssnz » Sun 26 Aug 2018 22:05

Hi all,

I'm using windows 10 version 1803, Entity Developer 6.3.555, Postgres 10.4

I have a table with a column of type timetz and a function that selects records based on an argument of type time.

On attempting to update my model in Entity developer I get this this error:
1 The DbType value of the parameter '_2' in the method 'FnPricesToDate' is not valid. The data type 'TIME WITH TIME ZONE' is not supported. C:\Users\***\DataAccess\***.lqml

Other time types show similar behavior. However, if I change the column and argument to a date type then the model will update correctly. But I want to be able to make that comparison based on time, not date.

How can I proceed?

Thanks

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

Re: support of functions with time data type arguments

Post by Shalex » Tue 28 Aug 2018 18:51

Thank you for your report. We will notify you when the issue with timetz is fixed.

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

Re: support of functions with time data type arguments

Post by Shalex » Fri 31 Aug 2018 17:44

The bug is fixed in the newest (7.11.1216) build of dotConnect for PostgreSQL.

ssnz
Posts: 19
Joined: Mon 20 Aug 2018 21:15

Re: support of functions with time data type arguments

Post by ssnz » Wed 05 Sep 2018 23:44

Thanks Shalex, it's working perfectly now

Post Reply