Even though I'm a little late, I feel compelled to act as I contributed to the development of the aforementioned query....The main issue I notice with Linq to Entities queries is that we typically provide superfluous arguments while building them, which could have an impact on the cached database query plan (so called ...Problem with SQL Server par...
When there is just one table, I have done the "fromsql" right off of the context; however, I recognise that this is not what you want, even if it advances the cause....var blogs = context.Blogs
.FromSql("SELECT * FROM dbo.Blogs")
.ToList();
...But in a situation like yours, it is complicated and involves the combining of many tables and CTE...
