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
creating-visual-studio-extensions-for-table-nodes-in-the-server-explorer-data-co[
^]
here I have checked and replicated the .vsct file like this:
scrennshot-vsct-file
from what I have seen from this it's kind of an structure so to how to display the extension command.
What I have tried:
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:
link1
link2
link3
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. Also if i change the GUID and Ids as mentioned , how am i supposed to hit my method/action in the command file. Please help me understand this.
Submit an article or tip