perform a select in npgsql
using System;
using Npgsql;
class Sample
{
static void Main(string[] args)
{
// Connect to a PostgreSQL database
NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;User Id=postgres; " +
"Password=pwd;Database=postgres;");
conn.Open();
// Define a query returning a single row result set
NpgsqlCommand command = new NpgsqlCommand("SELECT COUNT(*) FROM cities", conn);
// Execute the query and obtain the value of the first column of the first row
Int64 count = (Int64)command.ExecuteScalar();
Console.Write("{0}\n", count);
conn.Close();
}
}
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line