Home

Data Commander

Data Commander is a front-end for SQL and other databases. The program has a plugin architecture for adding arbitrary data providers.

How to build executable from source code

Open git_repository\DataCommander\DataCommander.Net-7.0\DataCommander.Net-7.0.sln in JetBrains Rider or Visual Studio. Build the solution.

Comparing to SQL Server Managament Studio

Object-relational mapping (ORM)

Features:

• The editor has syntax highlighting, code completion for SQL statements.
• The output of a query can be displayed as data grid, text, html.
• The data grid can be exported into Excel file.

Available providers

Microsoft SQL Server

Object Explorer

Server
    Databases
        System Databases
        Database Snapshots
        <Database>
            Tables
		        System Tables
                <Table>
                    Columns
                    Triggers
                    Indexes
            Views
			    System Views
                <View>
                    Columns
                    Triggers
            Programmability
                Stored Procedures
                    System Stored Procedures
			    Functions
                User-defined Table Types                
                Security
                    Users
                    Roles
                    Schemas
    Security
        Logins
    Server Objects
        Linked Servers
    Jobs

Object Explorer - Table node

How to script table to clipboard?

1. Right click to table
2. Script table as CREATE/SELECT/INSERT to clipboard.

Query textbox – code completion

How to list databases

1. Type use and press Crlt+J (List members)

How to list tables, views, functions in a database

1. Type select * from and press Ctrl+J

How to list columns of a table

1. Type select * from where . and press Ctrl+J

   How to list stored procedures, functions

   1. Type exec and press Ctrl+J

   How to list the distinct top 10 field values of a column

   1. Type select * from
   where . = and press Ctrl+J

   How to list global variables

   1. Type select @@ and press Ctrl+J

   How to list local variables

   1. Type select @ and press Ctrl+J

   PostgreSQL

   Object Explorer

   Schemas
   	Sequences
   	Tables
   		Columns
   	Views
   

   Team Foundation Server

   Available TFS commands (and samples):

   exec dir '<path>','recursion'
   	exec dir '$/','OneLevel'
   
   exec get 'serverPath','localPath'
   
   exec get '$/','C:\\Download'
   
   exec history 'path','user'
   exec history '$/EzYSK'
   exec history '$/','<username>'
   
   exec status 'path','recursion','workspace','user'
   exec status '$/'
   exec status '$/',null,null,'<username>'
   
   exec workspaces 'workspace','owner','computer'
   exec workspaces
   exec workspaces null,'<username>'
   

   License

   This program is freeware and released under the GNU General Public License.

   Development environment

   .NET 7 version:

   • C# 11
   • JetBrains Rider

   .NET 6 version:

   • C# 10
   • JetBrains Rider

   .NET 5 version:

   • C# 9.0
   • Microsoft Visual Studio Community 2019 Version 16.11.6 (editing Forms)

   .NET Framework 4.8 version:

   • C# 7.2
   • Microsoft Visual Studio Community 2019 Version 16.9.3
   • Resharper 2021.1.1
   • Microsoft .NET Framework 4.8 (Windows Forms UI)
   • .NET Standard 2.0 (Foundation class libraries)
   • .NET Core 2.2 (unit tests)

   Screenshots

   

   Credits

   JetBrains Resharper

   References

   • Microsoft SQL Server Management Studio
   • pgAdmin: PostgreSQL Tools
   • TOAD for SQL Server
   • PL/SQL Developer
   • Query Express
   • DBU
   • Blueshell Data Guy
   • QueryCommander
   • Free icons