Invalid Data Type: 'CITEXT'

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
cvboucher
Posts: 4
Joined: Wed 05 Aug 2015 21:43

Invalid Data Type: 'CITEXT'

Post by cvboucher » Thu 06 Aug 2015 18:21

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

Image

Thanks,
Craig

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Invalid Data Type: 'CITEXT'

Post by MariiaI » Mon 10 Aug 2015 05:19

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.

cvboucher
Posts: 4
Joined: Wed 05 Aug 2015 21:43

Re: Invalid Data Type: 'CITEXT'

Post by cvboucher » Mon 10 Aug 2015 19:54

Ok.
Thanks,
Craig

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Invalid Data Type: 'CITEXT'

Post by Shalex » Fri 17 Mar 2017 12:53

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

Post Reply