🟦 API Development with .Net

১

C# Syntax & Basic Data Types

C# program কাঠামো, primitive types

→ ২

Variables, Constants & Type Conversion

var, const, readonly, casting

→ ৩

Control Flow — if, switch, loops

Conditional statements, loops, switch expression

→ ৪

Methods, Parameters & Return Types

Method definition, params, ref/out, optional

→ ৫

OOP — Classes, Objects & Constructors

Class, object, constructor, properties

→ ৬

Inheritance, Interfaces & Polymorphism

Class inheritance, virtual/override, interface

→ ৭

Collections — List, Dictionary, Array

Generic collections in C#

→ ৮

Exception Handling — try/catch/finally

Exception, custom exception, using

→ ৯

LINQ — Query & Method Syntax

LINQ to Objects, projection, filtering

→ ১০

Async / Await — Async Programming Basics

async, await, Task, parallel I/O

→ ১১

Generics in C#

Generic class, method, constraints

→ ১২

File I/O & Streams

File, Directory, Stream, async file ops

→ ১৩

Delegates, Events & Lambdas

Delegate, Func, Action, event, lambda

→ ১৪

Nullable Types & Null Safety

int?, ?., ??, !, NRT, null forgiving

→ ১৫

.NET CLI — Create, Build, Run

dotnet command, project templates, NuGet

→ ১৬

ASP.NET Core Project Structure

Program.cs, appsettings, middleware pipeline

→ ১৭

Controllers, Routing & HTTP Verbs

[ApiController], [Route], action methods

→ ১৮

Model Binding, DTOs & Validation

DTO pattern, Data Annotations, FluentValidation

→ ১৯

Dependency Injection (DI)

Built-in DI container, lifetimes, constructor injection

→ ২০

Middleware Pipeline

Custom middleware, order, terminal/short-circuit

→ ২১

Configuration & appsettings.json

IConfiguration, Options pattern, secrets

→ ২২

Entity Framework Core — CRUD & Migrations

DbContext, DbSet, LINQ, migrations

→ ২৩

Connecting to MS SQL Server

Connection string, LocalDB, Azure SQL

→ ২৪

Dapper — Micro ORM & Raw SQL

Dapper, parameterized queries, performance

→ ২৫

MS SQL — Tables, Keys & Relations

CREATE TABLE, PK, FK, relationships

→ ২৬

SQL — CRUD Queries & JOINs

SELECT, WHERE, JOIN types, GROUP BY

→ ২৭

Stored Procedures & Functions

sp, scalar/table function, parameters

→ ২৮

Indexes & Query Optimization

Index types, EXPLAIN, query plan

→ ২৯

RESTful API Design Best Practices

Resource naming, versioning, status codes

→ ৩০

JWT Authentication

Token generation, validation, refresh token

→ ৩১

Role-based Authorization

Roles, policies, claims-based auth

→ ৩২

Global Error Handling & Custom Exceptions

Exception middleware, ProblemDetails, custom exceptions

→ ৩৩

API Versioning

Asp.Versioning, multiple versions

→ ৩৪

Repository Pattern & Unit of Work

Abstraction layer, IRepository, IUnitOfWork

→ ৩৫

CQRS Pattern with MediatR

Command Query Responsibility Segregation

→ ৩৬

Clean Architecture

Layered architecture, Domain/Application/Infrastructure/API

→ ৩৭

Caching — In-Memory & Redis

IMemoryCache, IDistributedCache, Redis

→ ৩৮

Pagination, Filtering & Sorting

Skip/Take, IQueryable, dynamic sort

→ ৩৯

Background Jobs — Hangfire / Hosted Services

IHostedService, BackgroundService, Hangfire

→ ৪০

SignalR — Real-time Communication

WebSocket, hubs, groups, broadcast

→ ৪১

Unit Testing with xUnit & Moq

xUnit, Moq, AAA pattern, FluentAssertions

→ ৪২

Integration Testing

WebApplicationFactory, TestServer, full stack tests

→ ৪৩

Rate Limiting & API Throttling

Built-in rate limiting (.NET 7+), policies

→ ৪৪

SQL Transactions & Concurrency Control

BEGIN TRANSACTION, isolation levels, optimistic/pessimistic

→ ৪৫

Swagger / OpenAPI Documentation

Swashbuckle, XML comments, JWT in Swagger UI

→ ৪৬

Logging with Serilog

Structured logging, sinks, enrichment

→ ৪৭

Docker — Containerizing .NET API

Dockerfile, multi-stage build, docker-compose

→ ৪৮

CI/CD with GitHub Actions

Workflow YAML, build, test, deploy

→ ৪৯

Microservices Architecture

Service decomposition, API Gateway, message broker

→ ৫০

MS SQL Performance Tuning

Execution plans, indexing strategy, partitioning

→