How do I disable interceptors when using them in Entity Framework

c# entity-framework entity-framework-6 web-config webdeploy

Question

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 sure that the site is not trying to write to a file that doesn't exist.

I started from this article: https://msdn.microsoft.com/en-us/data/jj556606.aspx#Interceptors

Here is my config section:

   <interceptors>
    <interceptor type="System.Data.Entity.Infrastructure.Interception.DatabaseLogger, EntityFramework">
      <parameters>
        <parameter value="C:\Temp\LogOutput.txt"/>
        <parameter value="true" type="System.Boolean"/>
      </parameters>
    </interceptor>
1
2
5/3/2015 2:46:04 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

For your purpose you do not need to write an interceptor. You can do the following setting in c# code:

#if DEBUG
    context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
#endif

After this when you are debugging all generated sql will be listed on the output. You can easily modify it to list it into a file also.

2
6/9/2017 5:29:07 PM

Popular Answer

To solve your scenario I would do what you are doing already and use configuration file transforms to make sure that section does not end up in the live environment.

Another option is to start using interceptors and settings them in code by using the DBInterceptors class. Then I would use C# directives to make sure the code is not called when in DEBUG mode. More on DBInterceptors here Logging and Intercepting Database Operations

I would still be using the first option though.

Omar Besiso

Related Questions

Adding existing entities to a collection on a newly built object using the entity framework

I am using the Entity framework to create a new order. The order contains a collection of contacts, a many to many relationship. I want to add a reference to an existing contact on the order on creation of the order. Both Order and Contact a Entity Objects.... Order order = new Order(); //set details on order Contact contact = new Contact();...
entity-framework many-to-many
asked by kirkmcpherson

When using Dapper with Entity Framework, should table constraints be relaxed or disabled?

I would like to set a do something like this ...dataSet1.EnforceConstraints = false;... using the Dapper.Net ORM and Entity Framework....I created the models in VS2010 where a property:... [EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)] [DataMemberAttribute()] public global::System.String ethnicname { ...
.net-4.0 dapper edmx entity-framework
asked by ElHaix

Connection closed when doing Transaction rollback on Mysql with Entity Framework 6 and Devart provider

I'm working on a project that uses Entity Framework 6 RC to connect to a Mysql database with the Devart provider(v7.8.322.0)....But now I run into a problem that when a query fails, the rollback of the transaction fails because the connection is closed....We are not starting any transactions ourselves....This is the stacktrace of the exception: ...
c# devart entity-framework-6 mysql transactions
asked by Steven Engels

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...
entity-framework entity-framework-5 entity-framework-6 entity-framework-extended
asked by quophyie

Adding Inner Join to DbScanExpression in Entity Framework Interceptor

I'm trying to use an Entity Framework CommandTree interceptor to add a filter to every query via a DbContext....For the sake of simplicity, I have two tables, one called "User" with two columns ("UserId" and "EmailAddress") and another called "TenantUser" with two columns ("UserId" and "TenantId")....Each time there is a DbScan of the User table, I...
c# entity-framework entity-framework-6 entity-framework-6.1
asked by Mark Johnson

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 queries. I've noticed a serious deficiency in documentation on this sort of thing. Two questions:...
c# entity-framework entity-framework-6 interceptor
asked by Amy

Entity Framework Interceptor set and populate custom value back after insert

I have an entity class that has a ...DateTime... property, ...LastModified..., that I would like to set its value using the Interceptor feature in Entity framework 6.1...I have created an EntityFramework interceptor that populates the insert command and correct sets the value in the INSERT statement....My pseudo code looks like this...Simple entity...
c# entity-framework entity-framework-6
asked by Dan

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 OptionRecompileHintDbCommandInterceptor());...What is the scope of this command and how do you limit the scope of an intercept...
entity-framework entity-framework-6 interceptor
asked by adam0101

Disable conversion between VARCHAR and NVARCHAR when using Entity Framework over an existing SQL server database

I have an existing database SQL server and I'm using EF6 over it. Let's assume I have the following code:...private sealed class Foo { public int Id { get; set; } public string Bar { get; set; } } private sealed class FooConfiguration : EntityTypeConfiguration<Foo> { public FooConfiguration() { ToTable("Foos"); Has...
.net entity-framework entity-framework-6 sql sql-server
asked by RX_DID_RX

Entity Framework 6: Updating entity when tracking is disabled on context

I'm hoping I can get some clarification on what the best practices are for using a ...dbcontext... with tracking disabled. What are the implications on setting the ...context.Configuration.ProxyCreationEnabled... to false?...As I understand it, this will effectively disable tracking on entities, but what if I then need to ...SaveChanges... with thi...
c# dbcontext entity-framework entity-framework-6
asked by benjovi

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow