Add ConnectionCreating/ConnectionCreated to DbConnectionInterceptor

[3GDXC]

I would like to make use and custom key value pairs on the ConnectionString to configure the mode of operation for the interceptors.

Adding the ConnectionCreating/ConnectionCreated would align with Command Interceptor and allow the developer to override the validation of the ConnectionString etc. internal to the provider to config the interceptors operations/mode

[roji]

@3GDXC any reason why you can't just use ConnectionOpening for that?

[3GDXC]

@roji using opening connection looks to happen after the call where the connection string is evaluated/validated and therefore any extra key/value pairs added for configuration of interceptor are causing exceptions; allowing a creating before actually creating the connection object would prevent this and allow interceptors to remove additional key/value pairs from the connection string.

[roji]

Is this a duplicate of #23085? See my code sample there.

[frandazzo]

Hi, i just tried to nuget the DbConnectionInterceptor (version 7) and tried to override the ConnectionCreating method that was not found.
It's a very important feature because in this way i can override the way a connection is created (with a custom conneciton factory for example). Any idea?

[ajcvickers]

@frandazzo Please open a new issue and attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.