Seemingly innocent Linq problem that had me baffled for ages
I came across an innocent-looking Linq problem the other day that really had me baffled for some time.
It's easiest explained using the ubiquitous Northwind database (although just about any other relational database would probably do). Suppose you want a list of customers with their orders. Pretty easy eh?
Erm no, it wasn't!