C# DotNet

Demo 🎥

Console App + Db with ADO.NET integrated with Microsoft Azure Data Studio (CRUD)

Simple Console App (CRUD)

Completed Topic ✅

• C#

• SQL

• Console App

• Console App + Db (Memory Database)

• Console App + Db (SQL Server)

  • ADO.NET (CRUD) – Old School
  • Dapper (CRUD) ORM – Micro ORM (query)
  • EFCore (CRUD) ORM – Full ORM (no query)
    • EF Core Installation For Command
      • dotnet tool install --global dotnet-ef
      • dotnet tool install --global dotnet-ef --version 7
    • Generate model from database
      • dotnet ef dbcontext scaffold "Server=.;Database=DbName;User Id=userId;Password=password;TrustServerCertificate=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models -c AppDbContext -t Tbl_Name -f (Note can stop building if smt err happens in code, so should put in somewhere but not main)
        Exclude "-t Tbl_Name" if you wanna extract all tables

• Postman

  • To run localhost, dotnet run --launch-profile https

• ASP.NET Core Web API

• Logic

• HttpClient

• RestSharp

• Refit

Project 1 setup

• For database setup, install the following

  • Microsoft.EntityFrameworkCore
  • Microsoft.EntityFrameworkCore.Design
  • Microsoft.EntityFrameworkCore.SqlServer
  • Microsoft.EntityFrameworkCore.Tools

• summary

  • Database > Table
  • Class Library > EFCore Install > Cmd
  • API Project > Add Class Library > EFCore (Dependecy injection)
  • API Project > Create Controller > CRUD using AppContext
  • Class Library > Domain > BlogService > API Project > Add > Register (builder.Services.AddScoped();)

  Demo

  Screen.Recording.2025-09-01.at.12.27.38.PM.mov

Project 3 setup

• Use Microsoft Azure Studio for Database

• Use Dapper C# + SQL To CRUD data from Database

• Use HTML, CSS, Bootstrap for frontend

  Demo

  Screen.Recording.2025-09-04.at.11.12.58.PM.mov

Packages

To install packages, check out nuget : https://www.nuget.org/