Invalid Data Type: 'CITEXT'

Invalid Data Type: 'CITEXT'

Postby 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/postgresql/docs/tutorial_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
cvboucher
 
Posts: 4
Joined: Wed 05 Aug 2015 21:43

Re: Invalid Data Type: 'CITEXT'

Postby 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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Invalid Data Type: 'CITEXT'

Postby cvboucher » Mon 10 Aug 2015 19:54

Ok.
Thanks,
Craig
cvboucher
 
Posts: 4
Joined: Wed 05 Aug 2015 21:43

Re: Invalid Data Type: 'CITEXT'

Postby Shalex » Fri 17 Mar 2017 12:53

The CITEXT data type is supported: http://forums.devart.com/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
Shalex
Devart Team
 
Posts: 7841
Joined: Thu 14 Aug 2008 12:44


Return to LinqConnect (LINQ to SQL support)