In this article we show how to develop a very common utility with ProcessStartInfo and Process classes included in System.Diagnostics namespace for PragmaSQL editor.

PragmaSQL T-SQL editor has very extensive add-in support. External Tools add-in presented in this article has two goals

1- Serve as PragmaSQL add-in development example.
2- Provide a very common feature included in all development IDEs and editors.

IC#Code Add-In Architecture Overview

PragmaSQL makes use of IC#Code's Add-In architecture. This architecture provides
fantastic fatures that enables us to develop plugins for our applications easily thus
making our applications extendable. IC#Code Add-In architecture provides

1- Simple and neat XML add-in definition via .addin files
2- Loading of add-in assemblies
3- Expose add-in functionality through menus and toolbars of the host application
4- And many utility services like MenuService and MessageService

For details about the architecture please refer to SODA - SharpDevelop Open Development Architecture by Mike Krueger

PragmaSQL Services Overview

PragmaSQL exposes many of the built-in host features to the add-in developers with a core librarary.
Exposed features include
More...

1. Copy the AddIn (.zip) file to your local folder.

2. Open PragmaSQL and go to Tools->AddIn Manager menu and open AddIn Manager dialog

3. In the AddIn Manager dialog click Install AddIn button. In the open file dialog select previously copied add-in file.

4. Restart PragmaSQL

1. Browse to C:\Documents and Settings\[Your user name]\ Application Data\PragmaSQL

2. In the specified folder above there is another folder name AddIns. In this folder there is one folder for each add-in you installed.

3.  Open the add-in folder you want to update

4.  Copy add-in files (if add-in files are in zip file extract files to your local) to the respective add-in folder.

5.  Restart PragmaSQL