Choose the Columns in C#

Last lesson, SELECT * gave you every column of the table. Most of the time you need fewer. A price list, for example, only needs each product's name and price, not its id, category or stock.

After SELECT, write the column names you want, separated by commas, without quotes. The answer has only those columns, in the order you list them. This reads each customer's name and city, and nothing else:

var query = "SELECT name, city " +
    "FROM customers ";

Choosing columns doesn't drop any rows: you still get one row per customer, just narrower. And you still need FROM: a column only exists inside a table. In C#, the statement also needs its ending: a line that ends with + carries on into the next line, until the ;.

Your query must print:

name | price
Mug | 12
Notebook | 7
Lamp | 29
Pen | 2
Plant | 15
Teapot | 22
Stapler | 9
Gift card | 50
(8 rows)

Your task: the connection db is already there. Write a query that reads each product's name, then its price, from the products table.

Assignment
Follow the Coding Tutorial to write a query that picks two columns of the products table: the name and the price.

Hint
Column names go after SELECT as plain words, with a comma between them. Keep the space at the end of each piece of the string, so the two lines don't run together. The first line ends with +, the last with ;.