| 1 | What are the most important Entity Framework Core best practices for building performant, reliable data access code? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 2 | What is Entity Framework Core, and how does it relate to the Repository and Unit of Work patterns? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Beginner |
| 3 | What is the difference between EF Core's Code-First (migrations) approach and Database-First (scaffolding) approach? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 4 | How does EF Core map inheritance hierarchies to database tables, and what are the three main strategies (TPH, TPT, TPC)? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 5 | What is the difference between First(OrDefault) and Single(OrDefault) in EF Core queries, and when should you use each? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 6 | How do you implement soft deletes in EF Core using a global query filter? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 7 | What is the N+1 query problem in EF Core, and how does eager loading with Include() solve it? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 8 | What is the difference between IQueryable<T> and IEnumerable<T> when writing EF Core queries, and why does it matter for performance? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 9 | How do you configure and use raw SQL queries alongside LINQ in EF Core when a complex query is difficult or inefficient to express in LINQ? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 10 | How does EF Core's change tracking work, and what is the difference between tracked and no-tracking queries? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 11 | How do EF Core migrations work, and what is the recommended workflow for applying them safely in production? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 12 | How do you handle optimistic concurrency conflicts in EF Core using a concurrency token (like RowVersion)? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 13 | How would you optimize an EF Core query that's generating inefficient SQL, and what tools help identify the actual generated SQL? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 14 | How does EF Core's compiled queries feature improve performance for frequently-executed queries, and when is it worth using? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Advanced |
| 15 | What is the difference between SaveChanges() and SaveChangesAsync(), and why does it matter for a web application's scalability? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Intermediate |
| 16 | What is a DbContext, and why should it generally not be shared across multiple concurrent operations? .NET › Entity Framework Core & Data Access | .NET | Entity Framework Core & Data Access | Beginner |
| 17 | What is ASP.NET Core Identity, and what does it provide out of the box? .NET › Authentication & Authorization (Identity, JWT, OAuth) | .NET | Authentication & Authorization (Identity, JWT, OAuth) | Intermediate |
| 18 | What is ASP.NET Core Identity, and how does it provide a complete user account management system? ASP.NET Core › Authentication | ASP.NET Core | Authentication | Intermediate |
| 19 | How do you safely access scoped services like a DbContext from within a BackgroundService, which is registered as a singleton? ASP.NET Core › Background Tasks & Hosted Services | ASP.NET Core | Background Tasks & Hosted Services | Intermediate |
| 20 | How do you implement resource-based authorization, where the authorization decision depends on the specific object being accessed, not just the user's general permissions? ASP.NET Core › Authorization | ASP.NET Core | Authorization | Advanced |
| 21 | How would you implement hierarchical or nested permission checks, like an organization admin having access to all of their organization's resources? ASP.NET Core › Authorization | ASP.NET Core | Authorization | Advanced |
| 22 | What are common cache invalidation strategies for ensuring cached data doesn't become stale, and why is invalidation considered a genuinely hard problem? ASP.NET Core › Caching | ASP.NET Core | Caching | Advanced |
| 23 | How would you cache the results of an expensive, paginated database query while correctly handling different page/filter parameter combinations? ASP.NET Core › Caching | ASP.NET Core | Caching | Advanced |
| 24 | How would you write a custom configuration provider to load settings from an unsupported source, like a remote configuration service or database? ASP.NET Core › Configuration & Options Pattern | ASP.NET Core | Configuration & Options Pattern | Advanced |
| 25 | What is the 'captive dependency' problem, and how does ASP.NET Core's DI container help catch it automatically? ASP.NET Core › Dependency Injection | ASP.NET Core | Dependency Injection | Advanced |
| 26 | How do you inject scoped (per-request) services into middleware, given that middleware classes are constructed once at app startup? .NET › ASP.NET Core Middleware & Request Pipeline | .NET | ASP.NET Core Middleware & Request Pipeline | Advanced |
| 27 | What are JWT claims, and how do you add custom claims when issuing a token? .NET › Authentication & Authorization (Identity, JWT, OAuth) | .NET | Authentication & Authorization (Identity, JWT, OAuth) | Advanced |
| 28 | What is the difference between Singleton, Scoped, and Transient service lifetimes in ASP.NET Core's DI container? .NET › Dependency Injection | .NET | Dependency Injection | Intermediate |
| 29 | What is Docker Compose, and how does it simplify running a multi-container .NET application locally (e.g., API + database + Redis)? .NET › Docker & Containerization | .NET | Docker & Containerization | Intermediate |
| 30 | How do you access the built IHost's service provider after Build() to resolve services outside the normal request/injection flow, such as in Program.cs itself? .NET › Generic Host | .NET | Generic Host | Intermediate |
| 31 | What's the difference between versioning a REST API's contract versus versioning its underlying data model, and why does that distinction matter? .NET › API Versioning | .NET | API Versioning | Advanced |
| 32 | How do you handle database schema changes that need to support multiple concurrently deployed API versions during a migration window? .NET › API Versioning | .NET | API Versioning | Advanced |
| 33 | How do you safely access scoped services (like a DbContext) from within a BackgroundService, which itself is registered as a singleton? .NET › Background Services | .NET | Background Services | Advanced |
| 34 | How do you set up automated database migrations as part of a .NET CI/CD deployment pipeline safely? .NET › CI/CD, Publishing & Deployment | .NET | CI/CD, Publishing & Deployment | Advanced |
| 35 | How would you write a custom configuration provider to load settings from an unsupported source, like a remote database? .NET › Configuration & Options | .NET | Configuration & Options | Advanced |
| 36 | How do multiple independently-registered BackgroundServices coexist within the same application, and does registration order matter? ASP.NET Core › Background Tasks & Hosted Services | ASP.NET Core | Background Tasks & Hosted Services | Intermediate |
| 37 | What is the difference between Singleton, Scoped, and Transient service lifetimes, and how does Scoped specifically map to an HTTP request? ASP.NET Core › Dependency Injection | ASP.NET Core | Dependency Injection | Intermediate |
| 38 | How do you use IServiceScopeFactory to manually create a DI scope outside the normal per-request pipeline, such as inside a background service? ASP.NET Core › Dependency Injection | ASP.NET Core | Dependency Injection | Intermediate |
| 39 | How would you implement cache-aside versus write-through caching patterns for a frequently-read, occasionally-written resource? ASP.NET Core › Caching | ASP.NET Core | Caching | Advanced |
| 40 | What is the significance of the order of AddHostedService registrations relative to StartAsync execution, and can you control it? .NET › Background Services | .NET | Background Services | Intermediate |
| 41 | What are common cache invalidation strategies, and why is cache invalidation considered a genuinely hard problem? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Intermediate |
| 42 | What is cache-aside (lazy loading) pattern, and how does it compare to write-through caching? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Intermediate |
| 43 | What is the purpose of health check response caching and how does frequent health check polling itself impact application performance? .NET › Diagnostics & Performance | .NET | Diagnostics & Performance | Intermediate |
| 44 | How would you implement cache tag-based invalidation to clear a group of related cache entries at once? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Advanced |
| 45 | How do you handle cache serialization for complex objects when using IDistributedCache, given it only natively supports byte[]? .NET › Caching (In-Memory, Distributed & Redis) | .NET | Caching (In-Memory, Distributed & Redis) | Advanced |
| 46 | What is the 'captive dependency' problem, and how does the DI container help catch it? .NET › Dependency Injection | .NET | Dependency Injection | Advanced |
| 47 | How do you use IServiceScopeFactory to manually create and manage a DI scope outside the normal request pipeline? .NET › Dependency Injection | .NET | Dependency Injection | Advanced |