Search found 5 matches

by luizg
Tue 24 Sep 2019 00:19
Forum: dotConnect for PostgreSQL
Topic: Problem with DbFunctions.TruncateTime
Replies: 12
Views: 52283

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.
by luizg
Fri 06 Sep 2019 02:00
Forum: dotConnect for PostgreSQL
Topic: Problem with DbFunctions.TruncateTime
Replies: 12
Views: 52283

Re: Problem with DbFunctions.TruncateTime

Any news about this issue?
by luizg
Sat 27 Jul 2019 17:38
Forum: dotConnect for PostgreSQL
Topic: Problem with DbFunctions.TruncateTime
Replies: 12
Views: 52283

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?
by luizg
Tue 16 Jul 2019 00:05
Forum: dotConnect for PostgreSQL
Topic: Problem with DbFunctions.TruncateTime
Replies: 12
Views: 52283

Re: Problem with DbFunctions.TruncateTime

No one?

Devart team? I would like to exchange the provider.
by luizg
Mon 15 Jul 2019 00:50
Forum: dotConnect for PostgreSQL
Topic: Problem with DbFunctions.TruncateTime
Replies: 12
Views: 52283

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?