Interview Q&A

Master technical and career interviews with structured answers—short definition, real examples, pitfalls, and how to answer in 60–90 seconds.

4608 total questions 4508 technical 100 career & HR 4272 from PDF library
Timed practice exams Career & HR Resume builder LinkedIn optimizer
All Career & HR Junior Mid Senior

Showing 151–154 of 154

Popular tracks

Microservices with .NET 697 C# Programming Tutorial 519 Design Patterns in C# 476 Developer Essentials 347 Microsoft Azure Tutorial 344 SQL Server Tutorial 310 JavaScript Tutorial 286 ASP.NET Core Tutorial 261 LINQ Tutorial 221 Node.js Tutorial 165 React.js Tutorial 160 Entity Framework Core Tutorial 154
Mid PDF
How to update only selected properties of an entity (partial updates)?

Short answer: Attach entity, then set only modified properties as Modified. Use context.Entry(entity).Property(p => p.PropertyName).IsModified = true. Useful for PATCH operations. Real-world example (ShopNest) ShopNes…

EF Core Read answer
Mid PDF
How to do bulk insert / bulk update / bulk delete (outside EF Core’s out-of-box, maybe with third party)?

Short answer: Use libraries like EFCore.BulkExtensions, Z.EntityFramework.Extensions. These provide optimized bulk operations, bypassing EF change tracking for performance. Real-world example (ShopNest) ShopNest’s order…

EF Core Read answer
Junior PDF
What is lazy loading proxy?

Short answer: EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Mic…

EF Core Read answer
Junior PDF
What is lazy loading proxy?

Short answer: How does the dynamic proxy work under the hood? EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires nav…

EF Core Read answer

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: Attach entity, then set only modified properties as Modified. Use context.Entry(entity).Property(p => p.PropertyName).IsModified = true. Useful for PATCH operations.

Real-world example (ShopNest)

ShopNest’s order service uses EF Core to save an Order and its line items in one SaveChangesAsync() call inside a transaction.

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: Use libraries like EFCore.BulkExtensions, Z.EntityFramework.Extensions. These provide optimized bulk operations, bypassing EF change tracking for performance.

Real-world example (ShopNest)

ShopNest’s order service uses EF Core to save an Order and its line items in one SaveChangesAsync() call inside a transaction.

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Microsoft.EntityFrameworkCore.Proxies. Proxy intercepts access and triggers loading when property is accessed.

Real-world example (ShopNest)

Loading orders with items uses .Include(o => o.Items). Without Include, listing 50 orders can trigger 50 extra queries (N+1).

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share

Entity Framework Core Entity Framework Core Tutorial · EF Core

Short answer: How does the dynamic proxy work under the hood? EF Core creates a dynamic proxy subclass of your entity at runtime. Proxy overrides virtual navigation properties to load related data on-demand. Requires navigation properties to be virtual and package Microsoft.EntityFrameworkCore.Proxies. Proxy intercepts access and triggers loading when property is accessed.

Real-world example (ShopNest)

Loading orders with items uses .Include(o => o.Items). Without Include, listing 50 orders can trigger 50 extra queries (N+1).

Say this in the interview

  1. Define — one clear sentence (the short answer above).
  2. Example — relate it to a project like ShopNest or your real work.
  3. Trade-off — when you would not use it.
Permalink & share
Toolliyo Assistant
Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com

Need callback? Share your details