You can store encrypted values in your ASP.NET Core configuration file and seamlessly decrypt the values as you retrieve them. But there are, at least, two issues that you'll need to address.

Take advantage of connection resiliency in EF Core to detect errors and retry commands and enable your ASP.NET Core application to overcome transient faults.

Take advantage of stored procedures, query pagination, query caching, and other advanced Dapper feature to simplify data access and ensure high performance.

If any of you have any suggestions on managing connection strings for your applications, I'd like to hear it. I know a couple of ways to do it, but I'm looking for the best way.In .NET 1.1, most ...