arrays

arrays

Postby seser » Sun 13 Feb 2011 13:21

does "linq connect for postgresql" supports array type fields;
seser
 
Posts: 17
Joined: Thu 13 Jan 2011 20:37

Postby StanislavK » Mon 14 Feb 2011 16:07

At the moment, it is only possible to retrieve array type values as strings. We will analyze the possibility of supporting array types, and post here when our investigation is completed.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby seser » Mon 14 Feb 2011 21:56

when i see pgsqlArray structure, i thouhgth that, i can't do it.
seser
 
Posts: 17
Joined: Thu 13 Jan 2011 20:37

Postby StanislavK » Wed 16 Feb 2011 14:52

It is possible to work with PostgreSQL arrays via the general ADO.NET components, like PgSqlDataReader and PgSqlCommand, and the PgSqlArray structure:
http://www.devart.com/dotconnect/postgresql/docs/Devart.Data.PostgreSql~Devart.Data.PostgreSql.PgSqlArray.html

However, within the LinqConnect ORM it is only possible to read PostgreSQL arrays as strings at the moment. For example, you can only map int[] to System.String in the model, and get the corresponding entity property as a string.

Please tell us if you encounter any problems with PgSqlArray, or have any additional questions about the PostgreSQL arrays support in LinqConnect/dotConnect for PostgreSQL.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL