support of functions with time data type arguments
Posted: 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
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