arrays

seser · Post by **seser** » Sun 13 Feb 2011 13:21

does "linq connect for postgresql" supports array type fields;

StanislavK · Post by **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.

seser · Post by **seser** » Mon 14 Feb 2011 21:56

when i see pgsqlArray structure, i thouhgth that, i can't do it.

StanislavK · Post by **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/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.