I'd love to know when EF opens and is about to close its connection to the database. I need to write a DbContext in which opening the connection sets the app role and the app role is unset just prior to closing the connection. Unfortunately, there is no Closing event on IDbConnection to grab on to.

Hi crmckenzie,

DbConnection itself is not part of the EF code and so we can't add a Closing event to it. That being said we would like to provide better event notifications to EF and this is one we would consider adding. However, it is possible for the connection to be closed outside of the control by EF meaning that even if we did add the event it would only indicate the EF is about to close the connection and not that the connection in general is about to be closed. I will try to get a work item filed to track this.

Thanks,
Arthur

I think it would be nice if EF used something like NHiberntate's ConnectionProvider. The control of the connection lifetime could then be separated from the DbContext, and users such as myself could set or unset application roles accordingly. Just an idea.

Will that help you?

DbContext context = new DbContext();
context.Database.Connection.StateChange += Connection_StateChange;

void Connection_StateChange(object sender, StateChangeEventArgs e)
{  
    /// Work With
    /// e.CurrentState
    /// e.OriginalState
}

No--because I need to unset the approle before closing the connection. The StateChanged event fires after the connection has been closed--not before.

Have you considered wrapping the connection and overriding Close()?