.NET Core Web API CRUD with PostgreSQL and Entity Framework Core

In this video we are going to learn, how to create REST Apis in .NET 9 with Postgres database. It is going to be a perfect tutorial for beginners who are just starting out. In this tutorial we learn:

How to create web apis in dotnet 9 from scratch
How to create dotnet REST APIs with postgres database
Dotnet REST API CRUD using Entity Framework core.
How to spin up Postgres using docker
How entity framework methods actually work

I have tried my best to explain every little detail about creating dotnet rest apis. However, there might be a possibility that something is missed or something got confusing. It that happens then feel free to ask me anything in the comment.


💻Source Code: https://github.com/rd003/DotnetPgDemo

⌨️⌨️ postgres docker

⌨️ 1. Pull docker image of postgress

docker pull postgres:16.9-bullseye


⌨️ 2. run the container

Note: This command works only on bash/GitBash because of \ symbol, which is a next line symbol in bash. For windows powershell you need to replace '\' with ` (backtick)

docker run --name pg-dev \
-e POSTGRES_PASSWORD=p@55w0rd \
-p 5432:5432 \
-v pgdata:/var/lib/postgresql/data \
-d postgres:16.9-bullseye

⌛ Chatpters:

(00:00:00 - 00:03:46) Tools needed
(00:03:46 00:07:46) Creating a new web api project
(00:07:46 - 00:08:13) C# dev kit
(00:08:13 - 00:10:45) Understanding the project structure
(00:10:45 - 00:14:14) WeatherForecast controller
(00:14:14 - 00:15:11) .http file and rest client extension
(00:15:11 - 00:22:33) Spinning up the postgres in a Docker container
(00:22:33 - 00:24:18) Ways to connect with database
(00:24:18 - 00:27:44) Required nuget packages
(00:27:44 - 00:30:20) AppDbContext
(00:30:20 - 00:32:23) Person.cs (model)
(00:32:23 - 00:33:36) DbSet
(00:33:36 - 00:40:36) Registering AppDbContext and connection string
(00:40:36 - 00:46:47) Creating database using Migrations
(00:46:47 - 00:50:27) PeopleController and injecting AppDbContext
(00:50:27 - 00:57:44) Post endpoint
(00:57:44 - 01:00:21 GetAll Endpoint
(01:00:21 - 01:03:34) Get (by id) endpoint
(01:03:34 - 01:06:34) Returning 201 CREATED from a POST endpoint
(01:06:34 - 01:13:02) Update endpoint
(01:13:02 - 01:16:18) Delete Endpoint

🔖Other links:
▶Code Crunch (precise c# .net videos):    • Code Crunch - Sort programming videos  
▶Single video courses:    • Asp.net core mvc (7.0 / 8.0) in one video ...  
▶dot net 6+ tutorials and projects:    • Dot net 6+ tutorials and projects  
▶Learn projects from scratch: https://bit.ly/3zpn9ng
▶Dotnet with different databases:    • dotnet with different databases  
▶Authentication and authorization:    • Authentication and authorization  
▶Design patterns with c#:    • Design Principles with c#  
▶Practical Oops with c#:    • Practical OOPs with c#  


🌟 Connect with me:
👉 Blog: https://ravindradevrani.com/
👉 YouTube:    / @ravindradevrani  
👉 Twitter:   / ravi_devrani  
👉 GitHub: https://github.com/rd003

☕Support my work:➡️ Buy me a coffee 🍵: https://www.buymeacoffee.com/ravindra...

#restapis #aspnetcore #entityframeworkcore #dotnet #csharp #programming