public void TestDeployerLocalSqlInstance() { var dbName = "TestDeployerLocalSqlInstance"; var connectString = String.Format(Utils.LocalInstanceConnectionString, dbName); var deployer = new SsdtServerDeployer(connectString, dbName, true); deployer.DeployDacPac(Utils.Dacpac); using (var c = new SqlConnection(connectString)) { c.Open(); using (var cmd = c.CreateCommand()) { cmd.CommandText = "TRUNCATE TABLE TESTTABLE"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } c.Close(); } deployer.DeleteDb(); try { using (var c = new SqlConnection(connectString)) { c.Open(); } Assert.Fail("Should have thrown Exception"); } catch (SqlException) { } }
public void TestCreateSqlDb() { var dbName = "TestDeployerCraeteOnLocalSqlInstance"; var connectString = String.Format(Utils.LocalInstanceConnectionString, dbName); if (DacHelper.DbExists(".", dbName)) { var deployer2 = new SsdtServerDeployer(connectString, dbName, false); deployer2.DeleteDb(); } Assert.IsFalse(DacHelper.DbExists(".", dbName)); var deployer = new SsdtServerDeployer(connectString, dbName, false); var name = dbName + ".mdf"; deployer.CreatDb(name); Assert.IsTrue(File.Exists(name)); using (var c = new SqlConnection(connectString)) { c.Open(); c.Close(); } deployer.DeleteDb(); Assert.IsFalse(File.Exists(name)); try { using (var c = new SqlConnection(connectString)) { c.Open(); } Assert.Fail("Should have thrown Exception"); } catch (SqlException) { } }