public void TestUsingExistingDb() { var fileName = "DeployerTestLocalDb2.mdf"; var logName = fileName.Replace(".mdf", "_log.ldf"); if (File.Exists(fileName)) { File.Delete(fileName); } if (File.Exists(logName)) { File.Delete(logName); } File.Copy("DeployerTestLocalDb.mdf", fileName); var deployer = new SsdtLocalDbDeployer(fileName, false); deployer.DeployDacPac(Utils.Dacpac, false); var connectString = String.Format(SsdtLocalDbDeployer.LocalDbConnectionString, fileName); 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.DetachDb(); File.Delete(fileName); File.Delete(logName); }
public void TestDeployerLocalDb() { var dbName = "TestDeployerLocalSqlInstance"; if (File.Exists(dbName + ".mdf")) { File.Delete(dbName + ".mdf"); } if (File.Exists(dbName + "_log.ldf")) { File.Delete(dbName + "_log.ldf"); } var deployer = new SsdtLocalDbDeployer(dbName + ".mdf", true); deployer.DeployDacPac(Utils.Dacpac); Assert.IsFalse(DacHelper.DbExists(SsdtLocalDbDeployer.LocalDbDataSource, deployer.DbName)); var connectString = String.Format(SsdtLocalDbDeployer.LocalDbConnectionString, dbName + ".mdf"); 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.DetachDb(); File.Delete(dbName + ".mdf"); File.Delete(dbName + "_log.ldf"); }
public static void AssemblyCleanup() { _server.DetachDb(); }