How to speed up LINQ+EntityFramework queries by using temp tables

Question

Looking where to share info about the extension that I'm working on I'm leaving here a couple of usefull links and observations.

EF6TempTableKit extends EF by utilizing temp tables which might be very helpful in terms of total execution time.

New, EF6TempTableKit 3.0.1 version is finally out. Apart from two bug fixes noted in the previous version, it's coming with a new feature. Say you are writing LINQ that relies on rarely changed data but needed to get query done. Typically, your query consists of additional join or subquery despite the fact that such data are already somehow cached in your .NET application. The new feature generates T-SQL insert query with a values based on in-memory data.

https://github.com/zblago/EF6TempTableKit/blob/master/README.md

NuGet Gallery | EF6TempTableKit 3.0.1