Settings

Settings

You can open the settings via the settings menu item in the title bar:

The settings provide the following options:

1. Appearance: The theme of the application (default themes provided by MahApps and you custom theme colors)
2. Server list: The list with your MS SQL server connections
3. Ignore list: The entries which should be ignored during the search
4. Various: Various settings like the export format
5. Import / Export: Import / Export of the settings

Appearance

Here you can make the settings for the accent color. You can choose from a list of standard colors (provided by MahApps) or add your own color.

Add your own color

To add you own color, click the Add button. In the dialog, you have to enter the name for the new color (have to be unique) and select a color via the color picker

If you have entered all information click on Ok to save you custom color or Cancel to exit the dialog without saving. Your new color will be appear in the list at the end with (Custom) in the name.

Important: Depending on the selected color, it may be that some texts / headings are no longer legible. Therefore, pay attention to what color you choose.

Delete a color

To delete a color, select the color and click on Delete.

Note: Only custom colors can be deleted.

Choose a color

Once you have selected a color, click Save to save it. If you exit the settings without saving the selected color, the original color will be restored.

Show / Hide tabs

If you do not need all the tabs, you can hide the tabs you do not need. To do this, uncheck the tabs you do not need and then click Save. To show a tab again, simply check the box again.

Only the tabs you require will be displayed.

Server

In the "Server" section, you can manage the connections to the desired servers.

You have the following options here:

1. Up / Down: Moves a server up or down in connection list (in the main window).
2. Add: Adds a new server / connection
3. Edit: Edits the selected server / connection
4. Delete: Deletes the selected server / connection

Add a server / connection

To add a new server / conneciton click on Add. After that, the server dialog will be opened:

• Server: The name / path of the MS SQL Server. For example (localdb)\MsSqlLocalDb for a local instance
• *Database: To load all available databases click on Connect. After that you will see all available databases. Now you can select your favorite database of the server.
• Auto connect: If you activate this option, a connection to the selected database is automatically established when you connect to the server
• Name: An optional name which will be shown behind the server name / path.

Edit a server / connection

Select the desired server / connection and click on Edit. The same dialog as under Add a server / connection will be shown.

Ignore list

If objects are not to be included in the search, they can be added here.

The ignore list is applied to the following areas:

• Search
• Definition export
• Class generator

Add a new entry

To add a new entry, select the desired Filter and add the Value. After that click on Add.

The following filters are available:

• Contains
• Equals
• Starts with
• Ends with

Delete an entry

To delete an entry, select the desired entry and click on Delete.

Various

Here you can manage some "other" settings like the Copy format or the search history count.

The Copy format specifies the format to be used when the content of a grid is copied with CTRL + C.

Note: If the option Copy only 'name' is selected, only the 'name' of a column is copied if only one row is selected. If the grid does not have a 'Name' column, the entire content of the column is copied in the specified format (see Copy format).

You have the following options:

• Markdown
• CSV
• ASCII Table
• JSON

Copy format example

Id	Name	Value
1	Fry	1
2	Bender	2
3	Leela	3

CSV

Id;Name;Value
1;Fry;1
2;Bender;2
3;Leela;3

Markdown

| Id | Name   | Value |
|----|--------|-------|
| 1  | Fry    | 1     |
| 2  | Bender | 2     |
| 3  | Leela  | 3     |

ASCII-Table

+----+--------+-------+
| Id | Name   | Value |
+----+--------+-------+
| 1  | Fry    | 1     |
| 2  | Bender | 2     |
| 3  | Leela  | 3     |
+----+--------+-------+

JSON

[
    {
        "Id": 1,
        "Name": "Fry",
        "Value": 1
    },
    {
        "Id": 2,
        "Name": "Bender",
        "Value": 2
    },
    {
        "Id": 3,
        "Name": "Leela",
        "Value": 3
    }
]

Import / Export

Here you can export your current settings and import someone else's settings, for example.

Note: If you check the option Override existing settings during import, all existing settings will be overwritten.