Problem with DbFunctions.TruncateTime

[luizg]

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?

[luizg]

No one?

Devart team? I would like to exchange the provider.

[Shalex]

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

[Shalex]

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

[luizg]

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?

[Shalex]

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

[luizg]

Any news about this issue?

[Shalex]

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

[Shalex]

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

[luizg]

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

Thanks.

[Shalex]

Good 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.

[juanchocr]

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

[DmitryGm]

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