Problem with DbFunctions.TruncateTime
Problem with DbFunctions.TruncateTime
Hello everyone,
I have a project in Entity Framework and PostgreSQL, currently it runs with Npgsql, but I'm having some problems with it and would like to test and switch to Devart.
I made the exchange, but at the moment I have a problem:
When using the "DbFunctions.TruncateTime" function I am getting the following error: "function date_trunc (unknown, unknown) is not unique". The generated SQL looks like this:
"SELECT *
FROM public.meta AS "Extent1"
where DATE_TRUNC ('day', "Extent1.")> = DATE_TRUNC ('day',: p__linq__1) "
By manually placing :: timestamp in the parameter, the query works.
This database was generated via migrations by Npgsql, the date column is of type "timestamp without timezone".
Can someone help me?
I have a project in Entity Framework and PostgreSQL, currently it runs with Npgsql, but I'm having some problems with it and would like to test and switch to Devart.
I made the exchange, but at the moment I have a problem:
When using the "DbFunctions.TruncateTime" function I am getting the following error: "function date_trunc (unknown, unknown) is not unique". The generated SQL looks like this:
"SELECT *
FROM public.meta AS "Extent1"
where DATE_TRUNC ('day', "Extent1.")> = DATE_TRUNC ('day',: p__linq__1) "
By manually placing :: timestamp in the parameter, the query works.
This database was generated via migrations by Npgsql, the date column is of type "timestamp without timezone".
Can someone help me?
Re: Problem with DbFunctions.TruncateTime
No one?
Devart team? I would like to exchange the provider.
Devart team? I would like to exchange the provider.
Re: Problem with DbFunctions.TruncateTime
We have reproduced the issue and will notify you when it is fixed.
Re: Problem with DbFunctions.TruncateTime
The bug with using DbFunctions.TruncateTime in EF6 is fixed: viewtopic.php?f=3&t=39079.
Re: Problem with DbFunctions.TruncateTime
Hello,
Now I have the same problem, but in another function:
function pg_catalog.date_part(unknown, unknown) is not unique
Can you fix this one too?
Now I have the same problem, but in another function:
function pg_catalog.date_part(unknown, unknown) is not unique
Can you fix this one too?
Re: Problem with DbFunctions.TruncateTime
Thank you for your report. We will notify you when the bug is fixed.
Re: Problem with DbFunctions.TruncateTime
Any news about this issue?
Re: Problem with DbFunctions.TruncateTime
The issue is fixed. We are planning to release the new public build next week.
Re: Problem with DbFunctions.TruncateTime
The bug with casting the DateTimeOffset value passed to a function as an argument in EF6 is fixed: viewtopic.php?f=3&t=39339.
Re: Problem with DbFunctions.TruncateTime
Good night, my trial period has expired, can you extend it so I can continue my tests with the new version?
Thanks.
Thanks.
Re: Problem with DbFunctions.TruncateTime
can i get a extemciom of my trial period.... i am an student
Re: Problem with DbFunctions.TruncateTime
Please create a support ticket via the contact form, so that we can offer you an extended trial.
https://www.devart.com/company/contactf ... postgresql