Git Docs

Blazor

1. Routing & navigating

• Default static
• Router
• Route Parameters
• Navigation

 @attribute [Route(Constants.CounterRoute)]

Minimal API

Shared

• Mapster

Scaffolding

MySQL

dotnet ef dbcontext scaffold "Server=localhost;Database=admin_portal_log;User=root;Password=root;" Pomelo.EntityFrameworkCore.MySql -o LogDbContextModels --context LogDbContext -f

dotnet ef dbcontext scaffold "Server=localhost;Database=admin_portal_config;User=root;Password=root;" Pomelo.EntityFrameworkCore.MySql -o ConfigDbContextModels --context ConfigDbContext -f

dotnet ef dbcontext scaffold "Server=localhost;Database=hppm;User=root;Password=root;" Pomelo.EntityFrameworkCore.MySql -o AppDbContextModels --context AppDbContext -f
dotnet ef dbcontext scaffold "Server=localhost;Database=hpmm;User=root;Password=root;" Pomelo.EntityFrameworkCore.MySql -o AppDbContextModels --context AppDbContext -t function -f

Queries (rote to backup file location)

sudo mysqldump -u username -p dbname.tablename > backupfile.sql
mysql -u username -p < backupfile.sql

SQL Server

dotnet ef dbcontext scaffold "Data Source=.;Initial Catalog=HPPM;Trusted_Connection=True;TrustServerCertificate=True;" Microsoft.EntityFrameworkCore.SqlServer -o SQLDbContextModels --context SQLAppDbContext -f

Database

Entity Framework Core

dotnet tool install --global dotnet-aspnet-codegenerator
dotnet tool install --global dotnet-ef
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.Tools 

MySQL

dotnet add package Pomelo.EntityFrameworkCore.MySql

SQL Server

dotnet add package Microsoft.EntityFrameworkCore.SqlServer

PostgreSQL

dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL.Design

Scaffold-DbContext "Host=localhost;Database=mydatabase;Username=myuser;Password=mypassword" Npgsql.EntityFrameworkCore.PostgreSQL -o PostgreDbContextModels

dotnet ef dbcontext scaffold "Host=localhost;Database=database;Username=username;Password=root" Npgsql.EntityFrameworkCore.PostgreSQL -o PostgreDbContextModels --context AppDbContext -f

"ConnectionString": "Server=localhost;Database=elearning;User Id=ed;Password=YourPassword;"

Learn PostgreSql

Naming Convension

• Table Name -> plural nouns, snake_case (products)
• Column Name -> snake_case with table name (product_id)
• Index Name -> idx_snake_case (idx_product_name)

[SQL Lite]

dotnet add package Microsoft.EntityFrameworkCore.Sqlite

Lite Db

dotnet add package LiteDB

QR Coder

QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode("The payload aka the text which should be encoded.", QRCodeGenerator.ECCLevel.Q);
QRCode qrCode = new QRCode(qrCodeData);
Bitmap qrCodeImage = qrCode.GetGraphic(20);

Refrences

ULID

dotnet add package Ulid

Redis

dotnet add package StackExchange.Redis

Docker Containerization with .Net

To Learn

.net 8 blazor

Reporting

Fast Report

FastReport.Web

Microsoft Identity

dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.EntityFrameworkCore.Sqlite
dotnet add package Microsoft.EntityFrameworkCore.Tools

builder.Services.AddAuthentication()
                .AddBearerToken(IdentityConstants.BearerScheme);

builder.Services.AddAuthorizationBuilder();

builder.Services.AddDbContext<AppDbContext>(options =>
{
    options.UseSqlite("DataSource=app.db");
});

builder.Services.AddIdentityCore<IdentityUser>()
    .AddEntityFrameworkStores<AppDbContext>()
    .AddApiEndpoints();

app.MapIdentityApi<IdentityUser>();

MS Identity

• Create project with Individual Accounts or add later
• Add Sample pages from Add New Item -> Scaffolded Item -> Identity
• Add Migration and Update Database