Originally from dotnet-snippets this lovely piece of code shows the power and danger of LINQ in one go:
var files = from file in new DirectoryInfo(@"C:\").GetFiles()
Sure, you could use that piece of code to search for files… but don't.
(Although surely it can't be long before someone adds deferred execution support for a filesystem? Maybe it's coming in WinFS Forever?)