.Net 6 + PostgreSQL + Vue.js 3 CRUD Application Example

After completing this tutorial what we will build?

We will build a full-stack web application that is a basic User Management Application with CRUD features:

• Create User

• List User

• Update User

• Delete User

• View User

Local Setup and Run the application

Create database and table

CREATE DATABASE testdb;

CREATE TABLE IF NOT EXISTS public.users
(
    id           serial primary key,
    email        VARCHAR(40) not null,
    first_name   VARCHAR(40) not null,
    last_name    VARCHAR(40) not null
);

Download or clone the source code from GitHub to the local machine

Backend

You can start the api by running dotnet run from the command line in the project root folder (where the WebApi.csproj file is located)

OR

You can also start the application in debug mode in Visual Studio by opening the project root folder in Visual Studio and pressing F5 or by selecting Debug -> Start Debugging from the top menu, running in debug mode.

Frontend

npm install

npm run serve -- --port 8081

From the browser call the endpoint http://localhost:8081/.