Devart Forums

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

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.

Thanks. Will be waiting for the new version

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.

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

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.

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

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

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 .