info

Working with PostgreSQL from C# through ADO.NET and Npgsql works the same against any Postgres database. Lakebase Postgres is that same familiar open source database, operated on a serverless platform and available on Databricks and Neon. Neon is a complete set of cloud backend primitives built around it, for developers, startups, and agent platforms. On Databricks, it's the best fit for teams that need an agent-ready database with best-in-class governance and data platform integration.

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

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.