Invalid Data Type: 'CITEXT'

[cvboucher]

PostgreSQL 9.4
Visual Studio 2015 Community
dotConnect for PostgreSQL Pro

I'm following the LinqConnect Tutorial with my own database.

https://www.devart.com/dotconnect/postg ... _linq.html

One of the columns is declared as citext. When I attempt to query that table/column I get the following exception:

An unhandled exception of type 'System.InvalidOperationException' occurred in Devart.Data.PostgreSql.Linq.dll

Additional information: Invalid data type: 'CITEXT'.



Thanks,
Craig

[MariiaI]

Invalid data type: 'CITEXT'.

Currently, this data type is not supported in LinqConnect.
This feature is on our roadmap and we will definitely inform you when the CITEXT data type is supported.

[cvboucher]

Ok.
Thanks,
Craig

[Shalex]

The CITEXT data type is supported: viewtopic.php?f=3&t=35130.

Please reset a default Entity Developer mapping in two steps (mappings are stored in different places):
* standalone via Tools > Options > Servers' Options > PostgreSQL > press Reset, then OK
* embedded into VS via Tools > Entity Developer > Options > Server Options > PostgreSQL > press Reset, then OK