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

Showing 1926–1950 of 3281

Career & HR topics

By tech stack

Popular tracks

Mid PDF
Join two lists with different types?

Short answer: Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types…

Mid PDF
Find the department with the most employees?

Short answer: Find the department with the most employees var mostPopulated = employees .GroupBy(e => e.Department) .OrderByDescending(g => g.Count()) .FirstOrDefault(); Find the department with the most employees…

Mid PDF
Find names of employees with even-length names .Where(e => e.Name.Length % 2 == 0)?

Short answer: var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); va…

Mid PDF
Find names of employees with even-length names?

Short answer: Find names of employees with even-length names var evenNames = employees .Where(e => e.Name.Length % 2 == 0) .Select(e => e.Name); Find names of employees with even-length names var evenNames = employ…

Mid PDF
Custom sort by name length, then alphabetically .OrderBy(e => e.Name.Length)?

Short answer: var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name)…

Mid PDF
Custom sort by name length, then alphabetically?

Short answer: Custom sort by name length, then alphabetically var customSort = employees .OrderBy(e => e.Name.Length) .ThenBy(e => e.Name); Follow : Custom sort by name length, then alphabetically var customSort =…

Mid PDF
Find if all employees earn above 50k?

Short answer: bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k…

Mid PDF
Find if any employee earns exactly 75000?

Short answer: bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Sala…

Mid PDF
Create lookup (multi-dictionary) of employees by department?

Short answer: var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e…

Mid PDF
Select department names that start with ‘F’ .Where(d => d.Name.StartsWith("F"))?

Short answer: var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.N…

Mid PDF
Select department names that start with ‘F’?

Short answer: Select department names that start with ‘F’ var deptNames = departments .Where(d => d.Name.StartsWith("F")) .Select(d => d.Name); Select department names that start with ‘F’ var deptNames =…

Mid PDF
Combine employee names with their department (string format)?

Short answer: var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $&qu…

Mid PDF
Find employees in 'IT' with salary > 80k?

Short answer: var itHighEarners = employees .Where(e => e.Department == "IT" && e.Salary > 80000); Example code var itHighEarners = employees .Where(e => e.Department == "IT" &&am…

Mid PDF
Skip first and last employee?

Short answer: Skip first and last employee var middle = employees .Skip(1) .Take(employees.Count - 2); Follow : Skip first and last employee var middle = employees .Skip(1) .Take(employees.Count - 2); Follow : Skip first…

Mid PDF
Find median salary (approx) s).ToList();?

Short answer: (salaries[salaries.Count / 2 - 1] + salaries[salaries.Count / 2]) / 2 : salaries[salaries.Count / 2]; var salaries = employees.Select(e => e.Salary).OrderBy(s => double median = salaries.Count % 2 ==…

Mid PDF
Find median salary (approx)?

Short answer: Find median salary (approx) var salaries = employees.Select(e => e.Salary).OrderBy(s => s).ToList(); double median = salaries.Count % 2 == 0 ? (salaries[salaries.Count / 2 - 1] + salaries[salaries.Cou…

Mid PDF
Use SelectMany to flatten nested collections new() { "A", "B" }, new() { "C", "D" } };?

Short answer: var nested = new List<List<string>> { var flat = nested.SelectMany(x => x); Example code var nested = new List<List<string>> { var flat = nested.SelectMany(x => x); Real-world…

Mid PDF
Use SelectMany to flatten nested collections?

Short answer: Use SelectMany to flatten nested collections var nested = new List<List<string>> { new() { "A", "B" }, new() { "C", "D" } var flat = nested.SelectMany(x =…

Mid PDF
Match employees with same salary .GroupBy(e => e.Salary) .Where(g => g.Count() > 1)?

Short answer: var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); va…

Mid PDF
Match employees with same salary?

Short answer: Match employees with same salary var duplicates = employees .GroupBy(e => e.Salary) .Where(g => g.Count() > 1) .SelectMany(g => g); Match employees with same salary var duplicates = employees .G…

Mid PDF
How to safely use First() with fallback

Short answer: var emp = employees.FirstOrDefault(e => e.Name == "Unknown") ?? new Employee { Name = "Default" }; Example code var emp = employees.FirstOrDefault(e => e.Name == "Unknown&quot…

Mid PDF
Replace foreach with LINQ ✅ This is not LINQ but syntactic sugar with List<T>.ForEach.?

Short answer: employees.ForEach(e =&gt; Console.WriteLine(e.Name)); employees.ForEach(e =&gt; Console.WriteLine(e.Name)); employees.ForEach(e =&gt; Console.WriteLine(e.Name)); employees.ForEach(e =&gt; Console.WriteLine(…

Mid PDF
Replace foreach with LINQ?

Short answer: Replace foreach with LINQ employees.ForEach(e =&gt; Console.WriteLine(e.Name)); Follow : ✅ This is not LINQ but syntactic sugar with List&lt;T&gt;.ForEach. Explain a bit more Replace foreach with LINQ emplo…

Mid PDF
Convert list to dictionary with name as key?

Short answer: var dict = employees.ToDictionary(e =&gt; e.Name, e =&gt; e); var dict = employees.ToDictionary(e =&gt; e.Name, e =&gt; e); var dict = employees.ToDictionary(e =&gt; e.Name, e =&gt; e); var dict = employees…

Mid PDF
Left join with fallback message join e in employees on d.Name equals e.Department into g from emp in g.DefaultIfEmpty() select new { Department = d.Name, Employee = emp?.Name?? "No employee" };

Short answer: var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join…

LINQ LINQ Tutorial · LINQ

Short answer: Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists… with different types var result = from e in employees join d…

Explain a bit more

in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals…

Example code

Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists… with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation = d.Location }; Join two lists with different types var result = from e in employees join d in departments on e.Department equals d.Name select new { e.Name, DeptLocation =… d.Location };

Real-world example (ShopNest)

A sales report joins orders and customers, then GroupBy(c => c.City) to show revenue per city.

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

LINQ LINQ Tutorial · LINQ

Short answer: Find the department with the most employees var mostPopulated = employees .GroupBy(e => e.Department) .OrderByDescending(g => g.Count()) .FirstOrDefault(); Find the department with the most employees var mostPopulated = employees .GroupBy(e => e.Department) .OrderByDescending(g => g.Count()) .FirstOrDefault(); Real-world example… (ShopNest) ShopNest uses…… LINQ to query orders: filter by date, project to a summary…

Explain a bit more

DTO, and order by total—readable C# that becomes SQL under EF Core. Find the department with the most employees var mostPopulated = employees .GroupBy(e => e.Department) .OrderByDescending(g => g.Count()) .FirstOrDefault(); Find the department with the most employees var mostPopulated = employees .GroupBy(e => e.Department) .OrderByDescending(g => g.Count()) .FirstOrDefault(); Real-world example… (ShopNest) ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name);

Example code

var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name); var evenNames = employees .Select(e => e.Name);

Real-world example (ShopNest)

ShopNest filters active products with products.Where(p => p.IsActive && p.Stock > 0) before showing the catalog.

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

LINQ LINQ Tutorial · LINQ

Short answer: Find names of employees with even-length names var evenNames = employees .Where(e => e.Name.Length % 2 == 0) .Select(e => e.Name); Find names of employees with even-length names var evenNames = employees .Where(e => e.Name.Length % 2 == 0) .Select(e => e.Name); Find names of employees with even-length names var evenNames = employees .Where(e =>… e.Name.Length % 2 == 0) .Select(e => e.Name); Find names of employees…

Explain a bit more

with even-length names var evenNames = employees .Where(e => e.Name.Length % 2 == 0) .Select(e => e.Name);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name);

Example code

var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name); var customSort = employees .ThenBy(e => e.Name);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: Custom sort by name length, then alphabetically var customSort = employees .OrderBy(e => e.Name.Length) .ThenBy(e => e.Name); Follow : Custom sort by name length, then alphabetically var customSort = employees .OrderBy(e => e.Name.Length) .ThenBy(e => e.Name); Follow : Custom sort by name length, then alphabetically var customSort = employees .OrderBy(e =>… e.Name.Length) .ThenBy(e => e.Name); Follow : Custom sort…

Explain a bit more

by name length, then alphabetically var customSort = employees .OrderBy(e => e.Name.Length) .ThenBy(e => e.Name); Follow :

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k =…

Example code

bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000); bool allAbove50k = employees.All(e => e.Salary > 50000);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000);

Example code

bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000); bool exact = employees.Any(e => e.Salary == 75000);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department);

Example code

var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department); var lookup = employees.ToLookup(e => e.Department);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name);

Example code

var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name); var deptNames = departments .Select(d => d.Name);

Real-world example (ShopNest)

ShopNest filters active products with products.Where(p => p.IsActive && p.Stock > 0) before showing the catalog.

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

LINQ LINQ Tutorial · LINQ

Short answer: Select department names that start with ‘F’ var deptNames = departments .Where(d => d.Name.StartsWith("F")) .Select(d => d.Name); Select department names that start with ‘F’ var deptNames = departments .Where(d => d.Name.StartsWith("F")) .Select(d => d.Name); Select department names that start with ‘F’ var deptNames = departments .Where(d =>… d.Name.StartsWith("F")) .Select(d => d.Name); Select department names that…

Explain a bit more

start with ‘F’ var deptNames = departments .Where(d => d.Name.StartsWith("F")) .Select(d => d.Name);

Real-world example (ShopNest)

ShopNest maps entities to DTOs with .Select(o => new OrderSummaryDto { Id = o.Id, Total = o.Total }) so the API does not leak internal fields.

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

LINQ LINQ Tutorial · LINQ

Short answer: var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var…

Explain a bit more

combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}");

Example code

var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}"); var combined = employees.Select(e => $"{e.Name} - {e.Department}");

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var itHighEarners = employees .Where(e => e.Department == "IT" && e.Salary > 80000);

Example code

var itHighEarners = employees
.Where(e => e.Department == "IT" && e.Salary > 80000);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: Skip first and last employee var middle = employees .Skip(1) .Take(employees.Count - 2); Follow : Skip first and last employee var middle = employees .Skip(1) .Take(employees.Count - 2); Follow : Skip first and last employee var middle = employees .Skip(1) .Take(employees.Count - 2); Follow : Skip first and last employee var middle = employees .Skip(1)…

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: (salaries[salaries.Count / 2 - 1] + salaries[salaries.Count / 2]) / 2 : salaries[salaries.Count / 2]; var salaries = employees.Select(e => e.Salary).OrderBy(s => double median = salaries.Count % 2 == 0

Real-world example (ShopNest)

ShopNest builds a LINQ query for search filters, then calls ToListAsync() once in the repository—so the SQL runs one time, not inside a loop.

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

LINQ LINQ Tutorial · LINQ

Short answer: Find median salary (approx) var salaries = employees.Select(e => e.Salary).OrderBy(s => s).ToList(); double median = salaries.Count % 2 == 0 ? (salaries[salaries.Count / 2 - 1] + salaries[salaries.Count / 2]) / 2 : salaries[salaries.Count / 2]; Find median salary (approx) var salaries = employees.Select(e => e.Salary).OrderBy(s => s).ToList(); double median = salaries.Count % 2 == 0 ?

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var nested = new List<List<string>> { var flat = nested.SelectMany(x => x);

Example code

var nested = new List<List<string>> {
var flat = nested.SelectMany(x => x);

Real-world example (ShopNest)

ShopNest maps entities to DTOs with .Select(o => new OrderSummaryDto { Id = o.Id, Total = o.Total }) so the API does not leak internal fields.

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

LINQ LINQ Tutorial · LINQ

Short answer: Use SelectMany to flatten nested collections var nested = new List<List<string>> { new() { "A", "B" }, new() { "C", "D" } var flat = nested.SelectMany(x => x); Use SelectMany to flatten nested collections var nested = new List<List<string>> { new() { "A", "B" }, new() { "C", "D" } var flat = nested.SelectMany(x => x); Real-world… example (ShopNest)… ShopNest… maps entities to DTOs with .Select(o => new…

Explain a bit more

OrderSummaryDto { Id = o.Id, Total = o.Total }) so the API does not leak internal fields. Use SelectMany to flatten nested collections var nested = new List<List<string>> { new() { "A", "B" }, new() { "C", "D" } var flat = nested.SelectMany(x => x); Use SelectMany to flatten nested collections var nested = new List<List<string>> { new() { "A", "B" }, new() { "C", "D" } var flat = nested.SelectMany(x => x); Real-world… example (ShopNest) ShopNest maps entities to DTOs with .Select(o => new OrderSummaryDto { Id = o.Id, Total = o.Total }) so the API does not leak internal fields.

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

LINQ LINQ Tutorial · LINQ

Short answer: var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g);

Example code

var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g); var duplicates = employees .SelectMany(g => g);

Real-world example (ShopNest)

ShopNest filters active products with products.Where(p => p.IsActive && p.Stock > 0) before showing the catalog.

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

LINQ LINQ Tutorial · LINQ

Short answer: Match employees with same salary var duplicates = employees .GroupBy(e => e.Salary) .Where(g => g.Count() > 1) .SelectMany(g => g); Match employees with same salary var duplicates = employees .GroupBy(e => e.Salary) .Where(g => g.Count() > 1) .SelectMany(g => g); Match employees with same salary var duplicates = employees .GroupBy(e => e.Salary) .Where(g =>… g.Count() > 1) .SelectMany(g => g); Match employees with…

Explain a bit more

same salary var duplicates = employees .GroupBy(e => e.Salary) .Where(g => g.Count() > 1) .SelectMany(g => g);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var emp = employees.FirstOrDefault(e => e.Name == "Unknown") ?? new Employee { Name = "Default" };

Example code

var emp = employees.FirstOrDefault(e => e.Name == "Unknown") ?? new
Employee { Name = "Default" };

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: employees.ForEach(e => Console.WriteLine(e.Name)); employees.ForEach(e => Console.WriteLine(e.Name)); employees.ForEach(e => Console.WriteLine(e.Name)); employees.ForEach(e => Console.WriteLine(e.Name));

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: Replace foreach with LINQ employees.ForEach(e => Console.WriteLine(e.Name)); Follow : ✅ This is not LINQ but syntactic sugar with List<T>.ForEach.

Explain a bit more

Replace foreach with LINQ employees.ForEach(e => Console.WriteLine(e.Name)); Follow : ✅ This is not LINQ but syntactic sugar with List<T>.ForEach. Replace foreach with LINQ employees.ForEach(e => Console.WriteLine(e.Name)); Follow : ✅ This is not LINQ but syntactic sugar with List<T>.ForEach. Replace foreach with LINQ employees.ForEach(e => Console.WriteLine(e.Name)); Follow : ✅ This is not LINQ but syntactic sugar with List<T>.ForEach.

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict =…

Explain a bit more

employees.ToDictionary(e => e.Name, e => e);

Example code

var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e); var dict = employees.ToDictionary(e => e.Name, e => e);

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

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

LINQ LINQ Tutorial · LINQ

Short answer: var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments

Example code

var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments var join = from d in departments

Real-world example (ShopNest)

ShopNest maps entities to DTOs with .Select(o => new OrderSummaryDto { Id = o.Id, Total = o.Total }) so the API does not leak internal fields.

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