Ravindra Devrani

REST Apis are session less. You can not maintain the authentication session for the whole application. For that purpose, JSON web token (JWT) comes in play. How it works:

• User hits the login or authenticate endpoint with valid credentials.
• In response, if user is authenticated, user get’s a access-token (JWT) , which contains the user’s info like username and role.
• You need to pass JWT in Authorization header with every protected endpoint.
• With this, the server knows a valid and authenticated user is accessing the resource.
• JWT has a expiry date, it does not live forever.
• Also need to note that, JWT is not saved in database.

What is the refresh token and why we need it?

You are thinking that, if I can do authentication with JWT, then why do I bother to create a refresh token. Let me break it down

TODO app is the most common way to understand basic crud (create, read, update and delete) feature of the language or framework or a ui library. But I prefer plain CRUD with form and table. In this way one can learn to use form along with validation also to display them in a table. It is a good way to learn CRUD for data driven appications like admin-panel for entries.

So….What is:

• React hook form: It is a popular light library to create and manage forms. It is very performative and comes with built-in validation support.

• **Zod **: It is a schema validation library that lets you define the shape of your data and validate it at runtime. It makes easier to do validation.

Create a react app with JS or TS whatever you prefer. After that install these packages in a react app:

• I am using mssql server in docker container.

• I am using vscode extension named SQL Server (mssql) by microsoft. This extension gives you the feature of creating and exporting the backup

• Connect to the database. It should look like this:

• Create a backup by using that extension.

Note: I have saved backup inside the folder /var/opt/mssql/data/

• To find the exact name:

docker exec <container_name> ls /var/opt/mssql/data/*.bak

• Copy backup from docker to host machine:

docker cp <container_name>:/var/opt/mssql/data/your_backup.bak ~/Documents/your_backup.bak

When you work with a team, everyone has their own preferences like double-quotes vs. single-quotes, trailing semicolon or not. If you want to decide a common code format that automatically applied. There are several ways which also comes with angular 21, like prettier. But you need to run the command for that every time. It is a nice feature. But you can also format code on file save. For that you need to follow these two steps.

Today we are going explore some popular learning techniques briefly. Yes… this post is not a regular technical blog post of this blog. But it might be helpful you are a “learner” (every programmer is a life long learner). I have described various techniques. Few of them fits very well in learning programming, deepen the concepts and research - while few are best suited for memorizing concepts for exams. Lets learn about each of them.

Aspnet core identity provides an UI to registration, login, manage users, password, external authentication (google, twitter, facebook etc). In simple words, We can say it is an authentication and authorization feature in just few lines of commands and code. It is a nice feature, if you don’t want to use other managed authentication providers like Azure Entra Id / Okta Auth0 etc.

Visual studio provides an UI way to enable identity. Which is very straightforward, but using CLI can be a little bit tricky. It is not always the case you are using visual studio (specially if you are using mac or linux). I use linux also. That is the whole reason to write this article.

In this tutorial, we are going to make dotnet core web api application and perform all the CRUD (create, read, update and delete). I have tried to keep it simple and avoided any complexities like repository pattern.

💻Source code

Tech and tools used

• Dotnet 10
• MySql 8+ (in docker container. Click here, if you want to create a MySql container in docker)
• Entity Framework Core (ORM)
• .NET CLI and VS Code (alternate Visual Studio 2025)

Creating a project

Execute these commands in a sequence.

In this tutorial, we are going to make dotnet core web api application and perform all the CRUD (create, read, update and delete). I have tried to keep it simple and avoided any complexities like repository pattern.

💻Source code

Tech and tools used

• Dotnet 10
• MySql 8+ (in docker container. Click here, if you want to create a MySql container in docker)
• Dapper (ORM)
• .NET CLI and VS Code (alternate Visual Studio 2025)

Create database

Let’s start with creating a database and a table. You need to execute this script.

Execute the command below.

For bash:

docker run -d \
  --name mysql-dev \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=p@55w0rd \
  -v mysql-data:/var/lib/mysql \
  mysql:8.0.44-debian

For powershell:

docker run -d `
  --name mysql-dev `
  -p 3306:3306 `
  -e MYSQL_ROOT_PASSWORD=p@55w0rd `
  -v mysql-data:/var/lib/mysql `
  mysql:8.0.44-debian

📢 For mac silicon specific:

mysql:8.0.44-debian does not support ARM architectureUse – so use mysql:latest instead of mysql:8.0.44-debian or check official docker hub for suitable image.