Error in displaying the Extension in SSMS created in Visual Studio (VSIX project) when right clicking any tables.

ciboligi ijavima 20 Reputation points
2024-02-15T04:14:45.7+00:00

I am trying to create an extension for the tables in any database which will be shown when I right click on any tables in SSMS, I want to run that extension from there. Furthermore, I want my extension to make insert queries, delete queries or any other queries on their own when user clicks on any table (as of now to make it simple lets say it just only prints a message "hello world!"). Please help with the same for any reference or from where and how to start approaching this kind of thing.

I took reference from this link https://stackoverflow.com/questions/45928398/creating-visual-studio-extensions-for-table-nodes-in-the-server-explorer-data-co
here I have checked and replicated the .vsct file like this:

Screenshot_24

from what i have seen from this it's kind of an structure so to how to display the extension command.


what I have done till now:
I took reference from the below links to first create an extension in SSMS tools bar using visual studio (VSIX project) and replicated the same as mentioned in the first link provided below:

  1. Detailed Explanation
  2. stackoverflow question
  3. Microsoft document

Also i have figured out how to find the GUID and GUID-ID when i press CLTR+SHIFT+Right click.


So now as this is done I am unable to understand how to approach the work I want to do as I mentioned above, since till now my extension is only visible in the tools menu which i don't want now i want it to be shown when i right click on any of my tables in the database. I know from the GUID i need to do something , but how that's the question and wanted to learn more about the structure of the above .vsct file.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,725 questions
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,950 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
181 questions
{count} votes