invaderzim85/mssqltoolbelt

Helper tool which provides a search, a class generator, a list of all custom tables, a definition export and some replication information of a MsSql database.

Hi there 😎

My name is Andreas and I'm a C# software developer and CPSA-F from germany.

Here one of my most favorite repos

And here some of my most used languages 😊

Here is a list of a few useful repos

Repository	Framework	Description	NuGet	Release
ZimLabs.Database.MySql	.net Standard 2.0	Class library for easy and fast connection to a MySql database.
ZimLabs.Database.MsSql	.net Standard 2.0	Class library for easy and fast connection to a Microsoft SQL database.
ZimLabs.CoreLib	.net 6	Small package with some helper functions
ZimLabs.Mapper	.net Standard 2.0	Class library which provides a auto mapper.
ZimLabs.WpfBase.NetCore - ARCHIVE	.net 5	WPF Class library which provides classes / functions for the easy use of MVVM in a WPF application		/
ZimLabs.TableCreator	.net 7	This library is not very special :) It takes a list of objects and creates an ASCII "table", markdown table or a CSV list. Very simple and straigt forward.
ZimLabs.Settings.Sqlite	.net 7	This library provides functions to manage settings using a SQLite database.

mssqltoolbelt's Issues

The Value cannot be an empty string

After clicking the export button for the tables, i get this error:

ClassGenTemplate - usings

Add the following usings to the class generator template which is used when a namespace is specified:

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

Add "MaxLength" attribute to string fields fo EF classes

Automatically add the MaxLength to attribute to string properties.

Example

[MaxLength(50)]
public string Name { get; set; } = string.Empty;

FK not shown

The foreign keys are missing in the index list.

SQL query to load the FKs:

SELECT
    *
FROM
    sys.foreign_keys AS fk

    INNER JOIN sys.tables AS t
    ON t.object_id = fk.parent_object_id
WHERE
    t.[name] = 'TABLENAME';

Copy & Paste Issue

There is an issue with the copy function within the table grid (search)

Index-Defragmentation

General

It's possible to load the defragmentation of table indexes with the Microsoft.SqlServer.Management.Smo class.

Functions

The following functions should be added:

1. Possibility to load the defragmentation of a single table
2. Possibility to rebuild an index of a single table
3. Possibility to load the defragmentation of a list of tables. It should be possible to add wildcards, so that the user can specify which table he/she likes to see.
4. Possibility to rebuilt the indexes which were loaded in step 3.
5. Export function (CSV, Markdown, JSON)

NOTE:

Since the process is very computationally intensive or takes a long time, the function should be designed in such a way that the user can cancel it and that the normal function of the program is not impaired.

Data annotation (DataType)

The data annotation for the data type has to be it's own attribute:

[Key]
[Column("Datum")]
[DataType(DataType.Date)]
public DateTime CreationDateTime { get; set; }

Max. Length shows wrong value

The max. length shows the wrong value.

SELECT DISTINCT
    c.[name],
    c.max_length AS [MaxLength]
FROM
    sys.columns AS c

    INNER JOIN sys.tables AS t
    ON t.object_id = c.object_id
WHERE
    t.name = 'CommentTable';

SELECT
    COLUMN_NAME,
    CHARACTER_MAXIMUM_LENGTH,
    CHARACTER_OCTET_LENGTH
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_NAME = 'CommentTable'