Entity Framework 7 Interceptor

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

You should enable the Auditor...var auditConfiguration = AuditConfiguration.Default; auditConfiguration.IncludeRelationships = true; auditConfiguration.LoadRelationships = true; auditConfiguration.DefaultAuditable = true; ...just add it to place where your app is initialized, Global.asax.cs for example...edited...Far as I know you can't get old val...

Adding Inner Join to DbScanExpression in Entity Framework Interceptor

The reason you obtained that exception is because InnerJoin produces a result combined of columns from both tables and on the other hand the query is supposed to return those matching properties of class User, so you additionally need to use projection at the end of query. Here is the code which worked for me:...public override DbExpression Visit(D...

How do I configure an Entity Framework interceptor in an aspnet vnext config.json file?

I actually think the functionality does not exist yet in EF7. It's on the backlog but does not seem to be implemented yet....https://github.com/aspnet/EntityFramework/issues/1629

Learning Entity Framework 6 command tree interceptors

I used the following references to help me implement a custom "soft delete" interception mechanism :...Entity Framework: Building Applications with Entity Framework 6... (as far as I remember, the part about interceptors is around min 20 with a focus on the ...SCAN... node which should answer your question)...How can I suppress execution from an En...

How do I disable interceptors when using them in Entity Framework

I am using Entity Framework 6.1.3 and have just implemented an interceptor so that I can view the generated SQL when developing locally. What is the correct method for disabling this interceptor when I publish my site to the LIVE environment? I am currently using a Web Config Transform through Web Deploy when publishing and I just want to make su...

Deleting parent-child relation with Entity Framework or Entity Framework Core

Your problem is that with a navigation property of null, EF will not check referential integrity (this will happen on SQL side)....However, this is necessary most of the time. Consider you want to attach a content to another category, you might want to do:...var content=context.Contents.FirstOrDefault(); content.CategoryId=2; context.Entry(content)...

Entity Framework Interceptor set and populate custom value back after insert

As explained here ...http://marisks.net/2016/02/27/entity-framework-soft-delete-and-automatic-created-modified-dates/...public class LastChangeInterceptor : IDbCommandTreeInterceptor { public const string LastChangeColumnName = "LastChange"; public const string LastChangeByColumnName = "LastChangeBy"; public void TreeCreated(DbCommandTr...

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

Two options I can think of for this, since it is at the global level, is in the query you want to single out, you can do something where you say 9 = 9 or something that is always true so you know it is the query you want. Then you could find and replace that where clause part with an empty string and then continue on with whatever you were going t...

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In my asp.net core web application, I am logging the exceptions to the database.Till now everything works fine but problem is that when the ...DbConext.SaveChanges... in try block throws an exception, cannot log the exception to the database as ...DbConext.SaveChanges... in ...catch block... also throws the same exception....Here is the code I hav...

Add migration - Both Entity Framework Core and Entity Framework 6 are installed

For EF6: ...EntityFramework\Add-Migration <MIGRATIONNAME> ...For EF Core:...EntityFrameworkCore\Add-Migration <MIGRATIONNAME>