Category: ASP.NET

Access data with connections, commands, and readers at a low level.

Use EF Core as the default ORM for ASP.NET Core apps.

Model entities, normalize thoughtfully, and plan indexes.

Create tables with 1:1, 1:N, and N:N relationships.

Identify rows with PKs and link tables with FKs.

Write SELECT/INSERT/UPDATE/DELETE with parameters from apps.

Combine tables with INNER/LEFT/RIGHT joins.

Harden APIs with authn/z, validation, rate limiting, and HTTPS.

Optimize EF queries, caching, and payload sizes.

Use SQL Server as the primary relational store for ASP.NET apps.