what is the correct way do define my connection with an already existing database on a server with SQL server authentication?

CodePudding user response：

Define in appsetting.json and using "Options pattern" we can get Connection String.

Refer below link for "Options pattern" https://docs.microsoft.com/en-us/aspnet/core/fundamentals/configuration/options?view=aspnetcore-6.0