I'm doing my first app in .NET 6 and using Entity Framework Core 6, using database first and the Scaffold-DbContext command to create the DbContext.

The only issue I have is trying to use the Name={connection string name} parameter rather than embedding the connection string. The app is a simple Console app (not an ASP.NET app) with an app.config file (can't use a JSON config file for other reasons). I added the connection to the config file like:

I get this error:

A named connection string was used, but the name 'ClientServices' was not found in the application's configuration. Note that named connection strings are only supported when using 'IConfiguration' and a service provider, such as in a typical ASP.NET Core application. See https://go.microsoft.com/fwlink/?linkid=850912 for more information.

What do I need to do so that the Scaffold-DbContext Name parameter can find my connection string? Looked at the link in the error, but it didn't help - was for ASP.NET apps.