🔍 Real-world LINQ = Practical
LINQ in the real world. Practical LINQ examples solve common business problems.
📝 Real-world Scenarios
// Employee Management
var employees = GetEmployees();
// Active employees with salary > 50000
var highEarners = employees
.Where(e => e.Active && e.Salary > 50000)
.OrderBy(e => e.Department)
.Select(e => new { e.Name, e.Department, e.Salary });
// Department statistics
var deptStats = employees
.GroupBy(e => e.Department)
.Select(g => new
{
Department = g.Key,
Count = g.Count(),
AvgSalary = g.Average(e => e.Salary),
MaxSalary = g.Max(e => e.Salary),
MinSalary = g.Min(e => e.Salary)
});
// Top performers per department
var topPerformers = employees
.GroupBy(e => e.Department)
.Select(g => g
.OrderByDescending(e => e.Salary)
.First());
// Employee hierarchy
var managers = employees
.GroupBy(e => e.ManagerId)
.Select(g => new
{
Manager = employees.First(e => e.Id == g.Key).Name,
Team = g.Select(e => e.Name).ToList()
});
🎯 Business Scenarios
// Sales Analytics
var orders = GetOrders();
// Monthly sales summary
var monthlySales = orders
.GroupBy(o => new { o.Year, o.Month })
.Select(g => new
{
g.Key.Year,
g.Key.Month,
Total = g.Sum(o => o.Amount),
Count = g.Count(),
Average = g.Average(o => o.Amount)
});
// Customer lifetime value
var customerValue = orders
.GroupBy(o => o.CustomerId)
.Select(g => new
{
CustomerId = g.Key,
OrderCount = g.Count(),
TotalSpent = g.Sum(o => o.Amount),
LastOrder = g.Max(o => o.OrderDate)
})
.OrderByDescending(c => c.TotalSpent);
// Product recommendations
var productPairs = orderItems
.GroupBy(oi => oi.OrderId)
.SelectMany(g => g
.SelectMany(i1 => g
.Where(i2 => i2.ProductId > i1.ProductId)
.Select(i2 => new { Product1 = i1.ProductId, Product2 = i2.ProductId })))
.GroupBy(p => new { p.Product1, p.Product2 })
.Select(g => new
{
g.Key.Product1,
g.Key.Product2,
Frequency = g.Count()
})
.OrderByDescending(p => p.Frequency);
// Inventory management
var lowStock = products
.Where(p => p.StockQuantity < p.ReorderLevel)
.OrderBy(p => p.StockQuantity)
.Select(p => new
{
p.Name,
p.StockQuantity,
p.ReorderLevel,
ToOrder = p.ReorderLevel - p.StockQuantity
});
💡 LINQ Tips
- Use meaningful variable names
- Break complex queries
- Consider performance
- Use ToList to execute
- Test with sample data
LINQ solves real business problems elegantly. These examples show its practical power.


