Pre-requisites

• dotnet-sdk
• dotnet ef tools
• dotnet tool install --global dotnet-ef
• dotnet dev-certs https –trust
• dotnet new
• docker
• postgreSQL docker
• docker compose
• PostgreSQL (use local postgreSQL instead of docker)
• visual studio code
• Extension
• C#
• C# Extensions
• NuGet Package Manager

Let’s get started

• cd document/projects
• dotnet new webapi –n AwesomeApi –f net5.0
• code .
• required assets to build and debug are missing from …. click yes
• run with ctrl + f5 or click the Run and Debug + click this play button
• open the app in your browser. Navigate to this URL https://localhost:5001/swagger/index.html
• if the your connection is nit private then run this command dotnet dev-certs https –trust
• add connection to PostgreSql Instance or Docker compose
• gist
• docker-compose up –d

• dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 5.0.2
• dotnet add package Microsoft.EntityFrameworkCore.Design --version 5.0.5
• Add Models folder
• Add new class as entity
• Add Data Folder (for persistance or abstarction to database)
• Create IDataContext
• Create DataContext than implement IDataContext
• Update appsetting.json
• Add Connection String
• Add Service to container on startup class
• do migration
• dotnet ef migrations add InitialMigration
• dotnet ef database update
• cek database created
• If use repository pattern
• create folder repository
• create interface and concrete classes
• add interface on repository to startup.cs
• create controller class
• create dto if needed
• enablel swagger (on .net5.0 swagger was adding on webapi template by default)