Character array insertion in postgresql using Npgsql

Question

I would like to insert an array of strings into a table in PostgreSQL using Npgsql in C#. I have written the code below but am getting an InvalidCastexception.

eventcommand.Parameters.AddWithValue("@participants", NpgsqlDbType.Array).Value = participant.Text;

where participant is an textbox and eventcommand is an NpgsqlCommand.

Jon Skeet · Accepted Answer · 2015-08-08 10:33:33Z

3

You're calling AddWithValue, but not providing the value - you're providing the type. Additionally, you're not providing an array - you're just providing a single string. I suspect you just want:

command.Parameters.Add("@participants", NpgsqlDbType.Array | NpgsqlDbType.Text).Value
    = new[] { participant.Text };

Or you may want to split participant.Text into an array of strings first, or something similar.

(I've adjusted the type as per comments.)

edited Aug 8, 2015 at 10:33

answered Aug 8, 2015 at 8:50

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

2 Comments

Shay Rojansky Over a year ago

Note also that NpgsqlDbType.Array needs to be bitwise ORed with the element type, so NpgsqlDbType.Array | NpgsqlDbType.Text for array of strings

Jon Skeet Over a year ago

@Shay: Thanks, fixed.

Collectives™ on Stack Overflow

Character array insertion in postgresql using Npgsql

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