Devart Forums

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

cvboucher wrote: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.

Ok.
Thanks,
Craig

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