Comment by bananas

LINQ isn't a magic bullet.

   collection.Where(s=>s.Transaction.Amount < 100).OrderBy(s=>s.Name).Single();

I'll let you debug the intermittent NullReferenceException that threw in production with no PDBs...