Productivity Tools

Tools written by an IT business manager, a passionate developer.

CreateSQLServerDatabase

Creates database on SQL Server. Used often before DBUp migrations.

Library allow us to create database from code. Database object exposes three methods:

During creation of database connection string cannot contain database name so library removes it from the connection string if provided. From connection string:

"Server=.\\sql2019;Database=PTMeetings;Integrated Security=True"

Library will make and use

"Server=.\\sql2019;Integrated Security=True"

Database object implement IDatabase interface, so you can inject it or use it in tests if required.

Usage example

Database database = new Database(name, "Server=.\\SQL2019;Trusted_Connection=True;"); database.Create();

Create database