In my opinion the let keyword is one of the most power features of LINQ.  Stuart Leeks posts about using let in LINQ to objects.

var query = from fileSystemInfo in fileSystemInfos
        where fileSystemInfo is FileInfo
        let fileInfo = (FileInfo)fileSystemInfo
        where fileInfo.Length < 1000
        select fileInfo;