public static List <string> CheckTablesStruct()
{
TableInfoRepo OriTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsOriginDbInfo());
TableInfoRepo CpyTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsCopyDbInfo());
List <string> list = new List <string>();
var listOri = OriTableRepo.GetInformation_Class();
var listCpy = CpyTableRepo.GetInformation_Class();
foreach (TableInfo oInfo in listOri)
{
foreach (TableInfo cInfo in listCpy)
{
if (oInfo.TABLE_NAME == cInfo.TABLE_NAME)
{
bool x = CheckTableStruct(oInfo.TABLE_NAME, OriTableRepo, CpyTableRepo);
if (x == false)
{
list.Add(oInfo.TABLE_NAME);
}
}
}
}
return(list);
}
public static List <string> GetNotMatchTableData()
{
TableInfoRepo OriTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsOriginDbInfo());
TableInfoRepo CpyTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsCopyDbInfo());
var listOri = OriTableRepo.GetInformation_Class();
var listCpy = CpyTableRepo.GetInformation_Class();
return(GetErrorList(listOri, listCpy));
}
private void CheckTablesStruct()
{
var listOri = oriRepo.GetInformation_Class();
var listCpy = cpyRepo.GetInformation_Class();
foreach (TableInfo oInfo in listOri)
{
foreach (TableInfo cInfo in listCpy)
{
if (isTableNameMatch(oInfo, cInfo) == true)
{
AddTableStructNotMatch(oInfo.TABLE_NAME, oriRepo, cpyRepo);
}
}
}
}