How to manage user secrets in .NET Core Console Application for EF Scaffolding?

Question

I'm making a .NET Core console application using VS 2019. I use EF Scaffolding using de NuGet console. In a MVC project I use the following command:

Scaffold-DbContext Name=ConnectionStrings:ClientConnection ....

Note that I use the alias that exists in the appesetting.json so that I don't explicitly put the database credentials in the command (for good practices purposes). Anyway this works in a MVC project as I said, but in a console app it does not accept the alias, I get the following error:

"A named connection string was used, but the name 'ConnectionStrings:ClientConnection' 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."

I have to explicitly add the connection string with everything so that it works.

How can I use the scaffold command using the "Name=ConnectionStrings:ClientConnection" without any problem in a .NET Core Console Application?

Can you share some code or etc. for clear understanding of your issue ? — Batuhan, Aug 18 '21 at 23:16
No code needed @Batuhan . Just executing the command a that's it — Luis Frediani, Aug 19 '21 at 00:37
https://stackoverflow.com/questions/45796776/get-connectionstring-from-appsettings-json-instead-of-being-hardcoded-in-net-co/58210975 — FarHard112, Aug 19 '21 at 01:39

How to manage user secrets in .NET Core Console Application for EF Scaffolding?

0 Answers0