Is there any way to override System.Data.SqlClient.SqlConnection?

Asked May 02 '19 at 11:49

Active May 02 '19 at 11:56

Viewed 474 times

I am using Secrets Manager to retrieve database credentials and store it in a cache. I was trying to handle a scenario when we do rotation on Secrets Manager, cache should be invalidated as soon as the connection to the database raise an error (catch the exception when credentials provided invalid) then try to retrieve the new credentials from Secrets Manager.

So, I come up with an idea to override SqlConnection constructor, so then I can attach a function to re-retrieve database credentials when it fails to connect to the database.

Anybody have any thoughts how to do this?

edited May 02 '19 at 11:56

jarlh

42,561
8
45
63

asked May 02 '19 at 11:49

Raymond Natio

1

This is not related to ANSI SQL, i.e. no need for that tag! – jarlh May 02 '19 at 11:57
1

It is not possible to do this via these means as the `SqlConnection` class is `sealed`. You would need use a different solution to rotate your credentials. – Martin Costello May 02 '19 at 12:01
Okay @jarlh sorry for that. Thank you Martin Costello for pointing out that. Cheers! – Raymond Natio May 02 '19 at 12:08

Is there any way to override System.Data.SqlClient.SqlConnection?

0 Answers0