private string PrintAllTableInfo(TransferRule aTr)
{
StringBuilder retVal = new StringBuilder();
retVal.AppendLine(SqlCommandRunner.GetTableInfo(aTr.DbsToTransfer[0].TablesToTransfer[0].TableName, _TempDbName));
retVal.AppendLine(SqlCommandRunner.GetTableInfo(aTr.DbsToTransfer[0].ProtectTableNames[0], _TempDbName));
retVal.AppendLine(SqlCommandRunner.GetTableInfo(aTr.DbsToTransfer[0].ProtectTableNames[1], _TempDbName));
return(retVal.ToString());
}
public void Test2()
{
//删除数据库1的一个表
SqlCommandRunner.DropTable(_MainTableName, _TempOtherDbName);
//表没有了，表信息就没有办法打印出来
try
{
Console.WriteLine(SqlCommandRunner.GetTableInfo(_MainTableName, _TempOtherDbName));
Assert.Fail();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//拷贝数据库的表过来作为替换
SqlCommandRunner.CopyTable(_MainTableName, _TempDbName, _TempOtherDbName);
Console.WriteLine(SqlCommandRunner.GetTableInfo(_MainTableName, _TempOtherDbName));
}