Entity Framework Generated SQL
Microsoft just recently released Visual Studio 2013, which includes Entity Framework 6 and introduces a lot of new features. It reminded me of the following query that EF generated for me, way, way back when it was still version 3.5. Here’s hoping that they’ve taken care of this problem since then.
So, the other day EF (v3.5) seemed to be taking quite a while to execute a query on SQL Server. This was a pretty central query and involved a few joins and restrictions, but wasn’t anything too wild. All of the restrictions and joins were on numeric fields backed by indexes.
In these cases, it’s always best to just fire up the profiler and see what kind of SQL is being generated by EF. It was a pretty scary thing (I’ve lost it unfortunately), but I did manage to take a screenshot of the query plan, shown below.
It doesn’t look too bad until you notice that the inset on the bottom right (the black smudgy thing) is a representation of the entire query … and that it just kept going on down the page.