SqlServerDbHelper_dotNET 1.0.3

Example: using SqlServerDbHelper;

string server = @"INSTANCE\SQLEXPRESS"; string database = "DEMODB"; string username = "sa"; string password = "";

string connectionString = @"Data Source="+ server + ";Initial Catalog="+ database + "; Trusted_Connection=True;User ID="+ username + ";Password="+ password + ""; DbHelper dbHelper = new DbHelper(connectionString);

Console.WriteLine("IsConnected: " + dbHelper.IsConnected()); if (dbHelper == null || !dbHelper.IsConnected()) { Console.WriteLine("Connessione non valida."); return; } Console.WriteLine("GetVersion: " + dbHelper.GetVersion()); Console.WriteLine("ConnectionString: " + connectionString); Console.WriteLine("GetConnectionTimeout: " + dbHelper.GetConnectionTimeout()); Console.WriteLine("Host: " + dbHelper.Server); Console.WriteLine("Database: " + dbHelper.Database); Console.WriteLine("UserID: " + dbHelper.UserID); Console.WriteLine("Password: " + dbHelper.Password);

string strTableNameAndSchema = "MyDB";

// Skip the backup if already exists if (dbHelper.IfBackupExists(connectionString, strTableNameAndSchema)) return;

string backUpLocation = @"D:\Backup"; string databaseName = strTableNameAndSchema; string backUpFileName = databaseName + "" + DateTime.Now.ToString("ddMMyyyy_HHmm") + "" + "sql2022";

string fileName = @"D:\Backup\backup.bak"; string istname = server;

// Restore if (dbHelper.RestoreDB(fileName, istname, databaseName, server) < 0) Console.WriteLine($"SQL Database Restore Failed");

// Backup if (dbHelper.BackupDatabase(backUpLocation, backUpFileName, databaseName, server, connectionString)) {

}

// Drop dbHelper.DropDatabase(connectionString);

// Start dbHelper.StartService();

// Stop dbHelper.StopService();