Page 1 of 1

arrays

Posted: Sun 13 Feb 2011 13:21
by seser
does "linq connect for postgresql" supports array type fields;

Posted: Mon 14 Feb 2011 16:07
by StanislavK
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.

Posted: Mon 14 Feb 2011 21:56
by seser
when i see pgsqlArray structure, i thouhgth that, i can't do it.

Posted: Wed 16 Feb 2011 14:52
by StanislavK
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/postgr ... Array.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.