Devart Forums

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?

No one?

Devart team? I would like to exchange the provider.

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

The bug with using DbFunctions.TruncateTime in EF6 is fixed: viewtopic.php?f=3&t=39079.

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?

Thank you for your report. We will notify you when the bug is fixed.

Any news about this issue?

The issue is fixed. We are planning to release the new public build next week.

The bug with casting the DateTimeOffset value passed to a function as an argument in EF6 is fixed: viewtopic.php?f=3&t=39339.

Good night, my trial period has expired, can you extend it so I can continue my tests with the new version?

Thanks.

luizg wrote: ↑Tue 24 Sep 2019 00:19Good night, my trial period has expired, can you extend it so I can continue my tests with the new version?

We have sent the extended trial to your email.

can i get a extemciom of my trial period.... i am an student

juanchocr wrote: ↑Mon 20 Jun 2022 01:55 can i get a extemciom of my trial period.... i am an student

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