Insert and Read row in one database call, Postgresql and C#

Question

Sorry if this is a silly question, how can we insert a row in postgresql database and read the same row again in one call?

ExecuteReader doesn't insert rows in database, ExecuteScalar and ExecuteNonQuery will return only one allow.

Is there a command to read entire row after inserting?

sm_ · Accepted Answer · 2015-09-10 14:19:19Z

1

You query has to have the two commands, end each command with a semi-colon

String query = @"INSERT INTO table (a,b) VALUES (1,'x');
SELECT * FROM table WHERE (a = 1);";

Use ExecuteReader(query) It will work fine.

Who said ExecuteReader can't be used for inserts ?

All 3 Execute- methods can execute whatever commands to the database however, ExecuteReader will read the returned rows, ExecuteNonQuery will not return any result, ExecuteScalar only returns the value from the first column of the first row of your query.

edited Sep 10, 2015 at 14:19

answered Sep 10, 2015 at 14:09

sm_

2,6122 gold badges19 silver badges34 bronze badges

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

2 Comments

manthan davda Over a year ago

Hi Siraj, Thanks for the answer I am passing Stored Proc in Execute Reader and its not inserting anything..

manthan davda Over a year ago

It was mistake from my side, Apologies :(

Collectives™ on Stack Overflow

Insert and Read row in one database call, Postgresql and C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related