When I select from a Pg table that contains a string array column, that column appears in my populated dataset as a single string, not a string array. Am I doing something wrong, or is this how dotConnect handles array retrieves ?
Here's a snippet:
Code: Select all
PgSqlCommand cmd = new PgSqlCommand(sql, _con );
cmd.CommandType = CommandType.Text;
PgSqlDataSet ds = new PgSqlDataSet();
try
{
PgSqlDataReader rdr = cmd.ExecuteReader();
ds.Load(rdr, LoadOption.OverwriteChanges, "Data");
}
catch (Exception ex)
{
throw new Exception("Error loading PostgreSQL data", ex);
}
return (ds);