dotConnect 4.9.152 does not support CITEXT field
-
- Posts: 5
- Joined: Mon 16 Aug 2010 19:54
dotConnect 4.9.152 does not support CITEXT field
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...."
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.
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.
-
- Posts: 5
- Joined: Mon 16 Aug 2010 19:54
dotConnect 4.9.152 does not support CITEXT field
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
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.
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.
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 .
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 .