c# retrieve _text type from postgresql

Question

I have a array like [["64", "0", "0"], ["64", "7", "95"], ["61", "28", "165"], ["60", "45", "200"]] in Postgres column which I stored from ruby on rails, and I want to retrieve it in my C# project. When I do this:

NpgsqlDataReader reader = command.ExecuteReader();
DataTable dt = new DataTable();
while (reader.Read())
{
    Console.WriteLine("{0}\t{1}", reader.GetName(0), reader.GetString(1));
}

I get the following exception:

System.InvalidCastException: Can't cast database type _text to String How can I get this column value as an Array But when I do:

dt.Load(reader);

foreach (DataRow row in dt.Rows)
{                
    var points = row["points"];
    var json = new JavaScriptSerializer().Serialize(points);
    Console.WriteLine(json);
}

it returns ["64","0","0","64","7","95","61","28","165","60","45","200"] which is not what I want.

Why the sqlite tag?

Panagiotis Kanavos
– Panagiotis Kanavos

2018-03-26 12:43:14 +00:00
Commented Mar 26, 2018 at 12:43 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Mar 26, 2018 at 12:43

dsdel · Accepted Answer · 2018-03-26 12:36:12Z

1

Please try:

string[,] result = row["points"] as string[,];

pgSql has an array field defined, so it cannot convert to string directly.

edited Mar 26, 2018 at 12:36

answered Mar 26, 2018 at 11:34

dsdel

1,0621 gold badge8 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Umes Bastola Over a year ago

please edit the answer to: string[,] result = row["points"] as string[,]; so that i can mark it as correct.. The array is 2 dimensional so it needs to be string[,]

dsdel Over a year ago

I am sorry for my mistake and thank you for the correction!

Collectives™ on Stack Overflow

c# retrieve _text type from postgresql

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related