.Net 6 + Microsoft SQL Server + 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 users (
  id              INT           NOT NULL    IDENTITY    PRIMARY KEY,
  first_name      VARCHAR(100)  NOT NULL,
  last_name       VARCHAR(100),
  email           VARCHAR(100)  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