How to optimize this LINQ query for Visual Studio?
I have this one gigantic complex LINQ to SQL query that I need to optimize somehow, because the background C# compiler completely hogs the CPU and I can't type or edit my .cs file normally in Visual Studio 2010 (every letter, especially if IntelliSense wants to pop up, lags horribly). The culprit is this: var custFVC = (from cfvc ...