dotConnect 4.9.152 does not support CITEXT field

dotConnect 4.9.152 does not support CITEXT field

Postby 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...."
jamesmuriithi
 
Posts: 5
Joined: Mon 16 Aug 2010 19:54

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby jamesmuriithi » Tue 17 Aug 2010 12:47

Thanks. Will be waiting for the new version
jamesmuriithi
 
Posts: 5
Joined: Mon 16 Aug 2010 19:54

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

dotConnect 4.9.152 does not support CITEXT field

Postby 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
PatrickG
 
Posts: 12
Joined: Thu 10 Mar 2011 21:51

Postby 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.
s_tristan
 
Posts: 9
Joined: Wed 06 Apr 2005 15:34

Postby AndreyR » Wed 06 Jul 2011 14:46

We are working on CIText support. It will be available in one of the nearest builds.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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
Devart Team
 
Posts: 7792
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7792
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL