PostgreSQL C#

This page shows how to manipulate data in a PostgreSQL database from C# applications using ADO.NET.

Section 1. Getting Started

This section helps you get started by showing you how to install the PostgreSQL driver for ADO.NET, connect to a PostgreSQL database, and create new tables

• Connecting to a PostgreSQL database – Learn how to install a Npgsql .NET Data provider and connect to a PostgreSQL database from a C# program.
• Creating new tables – Show how to create new tables in a PostgreSQL database from a C# program.

Section 2. Performing Common Database Operations

This section shows you how to perform common database operations such as inserting, updating, deleting, and retrieving data.

• Inserting data into a table – Learn how to insert a new row into a table in a PostgreSQL database from a C# program.
• Import a CSV file into a table – Show you how to load data from a CSV file into a table in a PostgreSQL database using ADO.NET.
• Updating data – Show you how to update data in a table in a PostgreSQL database from a C# program.
• Deleting data – Discuss how to delete data from a table in a PostgreSQL database from a C# program.
• Querying data – Show you how to query one or more rows from a table in a PostgreSQL database from a C# program.

Section 3. Transactions

This section guides you on how to perform a PostgreSQL database transaction in C# program

• Transaction – Learn to perform a database transaction in PostgreSQL database using C#.

Section 4. Calling PostgreSQL functions and stored procedure

This section shows you how to call PostgreSQL functions and stored procedures from C# programs.

• Calling a PostgreSQL Function – Show you how to call a PostgreSQL function from a C# program.
• Calling a Stored Procedure – Guide you on calling a stored procedure using C#.