Cross-platform?
Performance?
Microservices support?
Hosting?
CLR = Runtime (memory mgmt, GC, JIT)
CTS = Common type system
CLS = Language interoperability rules
Convert value → object = Boxing
Convert object → value = Unboxing
Gen 0, Gen 1, Gen 2
Managed heap
IDisposable, using
IDisposable
using
Task uses thread pool
Async frees thread, better scaling
Examples
Select, Where, Join, GroupBy, Any, FirstOrDefault
Select
Where
Join
GroupBy
Any
FirstOrDefault
Delegate = method pointer
Event = pub-sub model
Func<in,out> has return type
Func<in,out>
Action<> return void
Action<>
Request → Routing → Controller → Action → View
Authorization, Action, Result, Exception
Authorization
Action
Result
Exception
Constructor injection preferred
Built-in DI container in .NET Core
Use → Run → Map
Use
Run
Map
GET/POST/PUT/DELETE
Status codes (200,400,401,404,500)
CORS
JWT auth
Migrations in code-first
Reverse engineer DB-first
Include() for eager loading
Include()
join keyword or navigation properties
join
1NF, 2NF, 3NF
Clustered vs Non-clustered
Index usage problem = slow INSERT/UPDATE
INSERT/UPDATE
Function can’t call SP
Function must return value
Inner/Left/Right/Cross
Single Responsibility, Open-Closed, etc.
Abstraction over data layer
Token-based security
API Gateway, Service registry, Docker