Support for EF Core Compiled Queries

[ardalis]

Would it be possible to support EF Core Compiled Queries within the implementation of our Specification.EntityFrameworkCore package?

https://learn.microsoft.com/en-us/ef/core/performance/advanced-performance-topics?tabs=with-di%2Cexpression-api-with-constant#compiled-queries

[fiseni]

It's tricky. The compiled delegates should be strongly typed, otherwise you'd lose the benefits that you're getting by using compiled queries. In our case, we should dynamically construct the delegates. Also, we should be extra careful with parameters since only simple scalar parameters are supported.