Feature: Scaffolding context uses connections from the database tab

[patrickmilnes]

The way in which you input the required data for the connection is somewhat cumberson. I think it would be easier if it was a drop down that listed the connectsion from the db tab.

^ Db tab I am refering to.

Thanks
Pat

[seclerp]

Hi @patrickmilnes

We really like this UX improvement suggestion. It is possible to implement such autocompletion/dropdown, the main challenge with such an approach is that database connection from the Database tool window is not always convertible to the connection string format, used by EF Core.

This feature will likely be implemented only on well-known and most-used DBMS, where we could support such a mapping without issues.

We are also considering adding items from ConnectionStrings section of appsettings.json, appsettings.{env}.json, and user secrets.