public void WhenDbExists_ThenSetQueryStoreOff()
            {
                var connString = GetConnectionString(GetDbName());

                MsSqlServer.DeployDacpac(connString, TestFiles.Dacpac);

                Act(connString);

                MsSqlServer.DropDatabase(connString);
            }
            public void WhenDbExists_ThenDropDb()
            {
                var connString = GetConnectionString(GetDbName());

                MsSqlServer.DeployDacpac(connString, TestFiles.Dacpac);

                Act(connString);

                var exists = MsSqlServer.Exists(connString);

                Assert.That(exists, Is.False);
            }
            public void WhenDbExists_ThenReturnTrue()
            {
                var connString = GetConnectionString(GetDbName());

                MsSqlServer.DeployDacpac(connString, TestFiles.Dacpac);

                var result = Act(connString);

                Assert.That(result, Is.True);

                MsSqlServer.DropDatabase(connString);
            }
            public void WhenDbDoesNotExist_ThenCreateDb()
            {
                var connString = GetConnectionString(GetDbName());

                MsSqlServer.DeployDacpac(connString, TestFiles.Dacpac);

                var exists = MsSqlServer.Exists(connString);

                Assert.That(exists, Is.True);

                MsSqlServer.DropDatabase(connString);
            }
            public void WhenDacpacDoesNotExist_ThenThrowException()
            {
                var connString = GetConnectionString(GetDbName());

                Assert.Throws <InvalidOperationException>(() => MsSqlServer.DeployDacpac(connString, @".\DoesNotExist.dacpac"));
            }