dotConnect 4.9.152 does not support CITEXT field

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
jamesmuriithi
Posts: 5
Joined: Mon 16 Aug 2010 19:54

dotConnect 4.9.152 does not support CITEXT field

Post by jamesmuriithi » Mon 16 Aug 2010 20:11

I am currently developing an application that uses MS Entity Framework (EF) to access a PostgreSQL database (MyDatabase).
The database contains CITEXT fields that support text collation (the CITEXT module ships with v8.4 of PostgreSQL - You activate it by running the sql script in the citext.sql file)

I have tried to generate an Entity Framwork Model based on the PostgreSQL database containing CITEXT fields to no avail.

Here is the WARNING I receive

"The function 'translate' has a parameter 'p2' at parameter index 1 that has a data type 'MyDatabase.public.citext' which is not supported. The function was excluded...."

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 17 Aug 2010 09:33

We are investigating the possibility to add the citext support in one of the nearest build.
I will let you know as soon it is available.
As a temporary workaround, add a Devart Entity model to your project.
Drop the table containing citext field on the model designer. You will get an error message, that's OK.
Go to the Model Explorer; in Store part you will see an error indicator near the table that contains citext field.
Go to the property that has citext type and change the Type property to "varchar". Then drag this table from Store part of the model to the designer surface, you will obtain a type in the conceptual model.
I have performed these actions and succeeded.

jamesmuriithi
Posts: 5
Joined: Mon 16 Aug 2010 19:54

Post by jamesmuriithi » Tue 17 Aug 2010 12:47

Thanks. Will be waiting for the new version

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 17 Aug 2010 13:23

I recommend you to use the workaround.
We do not plan to add support for citext in the nearest build, and don't have a timefame for it to be implemented.

PatrickG
Posts: 12
Joined: Thu 10 Mar 2011 21:51

dotConnect 4.9.152 does not support CITEXT field

Post by PatrickG » Tue 07 Jun 2011 18:08

It has been almost 10 months since this post. I was wondering if there have been any changes to CITEXT support, or are any planned?

Patrick

s_tristan
Posts: 9
Joined: Wed 06 Apr 2005 15:34

Post by s_tristan » Tue 05 Jul 2011 14:39

Supporting of citext type is my requirement too to buy your product. I can easy adapt Npgsql, because I have a sources. But I need support for EF that your product has but ALSO of citext type.
I think investment of your resources to support citext type is important because this type permits using case-insensitive strings that is built-in in SQL Server.
So my vote.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 06 Jul 2011 14:46

We are working on CIText support. It will be available in one of the nearest builds.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 03 Aug 2011 10:43

The CITEXT data type is supported. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 12 Aug 2011 13:47

New build of dotConnect for PostgreSQL 5.30.202 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21729 .

Post Reply