Azure Data Studio (ADS) - create extension for CRUD with SQL Server databases?

Germo Görtz 6 Reputation points
2021-02-18T07:50:38.903+00:00

Would it be technically possible (and useful) to create an extension for Visual Studio Code (VSC) or Azure Data Studio (ADS) to allow simple CRUD (Create Read Update Delete) operations in SQL Server databases? Something similar to what you can do in Access via ODBC with databases: simple forms, using queries as lookup tables for selecting in fields, filtering, sorting, entering multi-line text data.

An ADS extension seems like a good place to me, since it's a good place to work with databases. However, I wouldn't know if and how an extension could do that at all. After all, you don't have that many options to extend the text editor: Go To Definition, Peek Definition. There wouldn't be so many possibilities to somehow build something like forms.

About Webview the documentation says:

Just because you can do something with webviews, doesn't mean you should.

Overall, this sounds like a warning to use webviews only when you can't do it any other way.

What would be other reasonable ways?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,606 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,071 Reputation points Microsoft Vendor
    2021-02-19T06:37:19.057+00:00

    Hi @Germo Görtz ,

    SQL server general tag is not the correct tag for your issue. I am not familiar with Azure Data Studio. I search this from internet.

    In ADS SQL code snippets generate the proper SQL syntax to create databases, tables, views, stored procedures, users, logins, roles, and to update existing database objects. Use smart snippets to quickly create copies of your database for development or testing purposes, and to generate and execute CREATE and INSERT scripts. Refer to What is Azure Data Studio?

    For creating Azure Data Studio extensions, please refer to Extend functionality by creating Azure Data Studio extensions to get more information.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

  2. CathyJi-MSFT 21,071 Reputation points Microsoft Vendor
    2021-02-22T02:44:44.133+00:00

    Hi @Germo Görtz ,

    > maybe you could suggest a better place to ask this kind of questions (about Azure Data Studio or about Visual Studio Code development)

    For questions about Visual Studio Code development, you can ask your question on Stack Overflow(Question tagged visual-studio-code) or enter issues and feature requests directly in GitHub repository.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments
  3. Germo Görtz 6 Reputation points
    2021-02-22T09:08:30.217+00:00

    @CathyJi-MSFT

    • As I wrote, the first place where I asked was StackOverflow, but the question was rejected and closed. I don't understand, why.
    • GitHub was also an idea, but the "discussion" is not enabled in this project. And "Issues" would not be the right place, because there should be published bugs or feature request. My question is neither a bug nor a feature request.

    Probably this is a sign: I should not bother trying to do such things with Azure Data Studio or Visual Studio Code :-)

    0 comments