EFCorePowerTools
EFCorePowerTools copied to clipboard
[Feature] Add: "Scaffold Data API Builder configuration" to Server Explorer context menu
This is stage 0.9, just to get something out!
1: Server Explorer can store connections to SQL Server/Azure SQL by default, and additional DDEX providers for Postgres and more are available. Connections to MS SQL and Postgres are supported
2: Show tables, views and SQL Server (not Postgres) stored procedures, including all columns
3: For this iteration, use this algorithm to determine a suggested key for a view, and indicate visually with a spcial icon. Add comment about the key choice in the output:
- Pick first column named Id
- Else pick first column ending in Id
- Else pick first column
4: Output:
- .cmd file with commands to install DAB CLI and run the required config commands with comments as needed
- explicitly specify each table with all columns chosen
- maybe a readme.md file with additional links and steps to consider?
@jerrynixon FYI