Entity Framework 6 - Knowledge Base (KB)

Intercept all EF6 Linq queries

I have a function which I want to run on every executed Linq query on a DbContext to modify the expression tree before execution. I've been having a look at the IDbCommandTreeInterceptor interface but that doesn't seem to provide an expression tree (whic...

Getting DbContext from implementation of IDbCommandInterceptor

I am using an ...IDbCommandInterceptor... implementation:...public class MyInterceptor : IDbCommandInterceptor { public void ReaderExecuting(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext) { var context =...

Learning Entity Framework 6 command tree interceptors

This is purely a learning experiment (yay science!). This is not meant to actually be used anywhere. I want to learn how EF6's command tree interceptors work....I'm trying to modify the intercepted command tree to add a "IsActive = 1" filter to all quer...

Entity Framework Command Intercept change context connection string

Goal...: ...fall back to the backup database when the main one is not reachable / down....Current implementation...: ...when issue is detected, use class implementing ...IDbCommandInterceptor... to change connection string to fallback server....Close conn...

Hooking IDbInterceptor to EntityFramework DbContext only once

The ...IDbCommandInterceptor... interface is not very well documented. And I've only found a few scarce tutorials on it:...http://www.entityframeworktutorial.net/entityframework6/database-command-interception.aspx...https://msdn.microsoft.com/en-us/data/j...

How can I add an interceptor to a single query in Entity Framework?

I have a query that I suspect is guilty of parameter-sniffing. I'd like to apply an interceptor like the one found ...here..., but I don't want any other queries affected....The code used there is: ...DbInterception.Add(new OptionRecompileHintDbCommandInt...