using Npgsql; using System; NpgsqlConnection connection = new NpgsqlConnection("Server=127.0.0.1;User Id=username;Password=password;Database=my_db;"); connection.Open(); try { using (NpgsqlCommand cmd = new NpgsqlCommand("INSERT INTO my_table (col1, col2, col3) VALUES (@val1, @val2, @val3)", connection)) { cmd.Parameters.AddWithValue("val1", 1); cmd.Parameters.AddWithValue("val2", "some value"); cmd.Parameters.AddWithValue("val3", DateTime.Now); cmd.ExecuteNonQuery(); } } finally { connection.Close(); }
using Npgsql; using System; NpgsqlConnection connection = new NpgsqlConnection("Server=127.0.0.1;User Id=username;Password=password;Database=my_db;"); connection.Open(); try { using (NpgsqlCommand cmd = new NpgsqlCommand("my_stored_procedure_name", connection)) { cmd.CommandType = CommandType.StoredProcedure; // Add any required parameters cmd.Parameters.AddWithValue("param1", 1); cmd.Parameters.AddWithValue("param2", "some value"); cmd.Parameters.AddWithValue("param3", DateTime.Now); using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { // Process results } } } } finally { connection.Close(); }This code executes a stored procedure on the PostgreSQL database, passing parameters and retrieving results. The Npgsql package library is available on NuGet.