SDG-Backend-Barracuda

This is an ASP.NET Core Web API with a PostgreSQL backend, using Dapper for high-performance data access.

Prerequisites

PostgreSQL Database Setup

Follow these steps to set up your local PostgreSQL database:

1. Create Database and User

If you haven't already, create a database and a user with appropriate permissions. You can use psql or a tool like pgAdmin.


-- Create SDG-Backend-Admin
CREATE USER "SDG-Backend-Admin" WITH ENCRYPTED PASSWORD 'password';

-- Create the database
CREATE DATABASE "SDG-Backend" OWNER "SDG-Backend-Admin";

2. Configure Connection String

Initialize User Secrets

Run this in the project directory (SDG-Backend-Barracuda\SDG-Backend-Barracuda):

dotnet user-secrets init

Set the Connection String

Replace password if you used a different one during setup:

dotnet user-secrets set "ConnectionStrings:DefaultConnection" "Host=localhost;Database=SDG-Backend;Username=SDG-Backend-Admin;Password=password;Maximum Pool Size=100;"

Development

Installing Dependencies

The project uses Npgsql, Dapper, and Npgsql.DependencyInjection.

dotnet add package Npgsql
dotnet add package Dapper
dotnet add package Npgsql.DependencyInjection

Running the Application

From the root directory:

dotnet run --project SDG-Backend-Barracuda

1.5 KiB Raw Permalink Blame History