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...
