Using C# in Visual Studio, I'm inserting a row into a table like this:
INSERT INTO foo (column_name) VALUES ('bar')
I want to do something like this, but I don't know the correct syntax:
INSERT INTO foo (column_name) VALUES ('bar') RETURNING foo_id
This would return the
foo_id column from the newly inserted row.
Furthermore, even if I find the correct syntax for this, I have another problem: I have
SqlDataAdapter at my disposal. As far as I know, the former is for reading data, the second is for manipulating data. When inserting a row with a return statement, I am both manipulating and reading data, so I'm not sure what to use. Maybe there's something entirely different I should use for this?