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 AssemblyInit(TestContext context) { _server = new SsdtLocalDbDeployer(DbName, true); #if DEBUG var dacPackageFile =Path.GetFullPath(Path.Combine(Environment.CurrentDirectory, @"..\..\..\CpsDbHelper.TestDatabase\bin\Debug\CpsDbHelper.TestDatabase.dacpac")); #else var dacPackageFile = Path.GetFullPath(Path.Combine(Environment.CurrentDirectory, @"..\..\..\CpsDbHelper.TestDatabase\bin\Release\CpsDbHelper.TestDatabase.dacpac")); #endif _server.DeployDacPac(dacPackageFile); }