EFCorePowerTools icon indicating copy to clipboard operation
EFCorePowerTools copied to clipboard

[Feature] Add: "Scaffold Data API Builder configuration" to Server Explorer context menu

Open ErikEJ opened this issue 1 year ago • 0 comments

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

ErikEJ avatar Jun 12 '24 08:06 ErikEJ