How to get distinct by multiple properties?
Short answer: How to get distinct by multiple properties?
Explain a bit more
var distinctByDeptAndSalary = employees .GroupBy(e => new { e.Department, e.Salary }) .Select(g => g.First()); How to get distinct by multiple properties? var distinctByDeptAndSalary = employees .GroupBy(e => new { e.Department, e.Salary }) .Select(g => g.First()); How to get distinct by multiple properties? var distinctByDeptAndSalary = employees .GroupBy(e => new { e.Department, e.Salary }) .Select(g => g.First()); How to get distinct by multiple properties? var distinctByDeptAndSalary = employees .GroupBy(e => new { e.Department, e.Salary }) .Select(g => g.First());
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
- Define — one clear sentence (the short answer above).
- Example — relate it to a project like ShopNest or your real work.
- Trade-off — when you would not use it.
Share this Q&A
Share preview image: https://www.toolliyo.com/images/toolliyo-logo.png